Power BI question

I created all these fancy displays of information in Ignition from our production, which I think is the proper software for the usage.

Now, a less technical team wants to show a bunch of information and Power BI is already connected to their equipment.

My gut says to push them on to work with Power BI, which I never used.
How does one know when something should be developed in Power BI or in Ignition?
Or at least what are good indicators?

PowerBI is not real-time and does not have PLC drivers.

It gets its data from relational DBs'. So can Ignition of course.

PBI is a monthly subscription, Ignition is a one-time purchase (excluding support).

1 Like

Power BI is not realtime?

It's as real-time as the data in your DB...

It is not SCADA.

1 Like

It is funny because my "real-time" pages are from my DB with 10 to 30 second update intervals.
So I wasn't sure what you meant, but I think I understand now.

When reporting/dashboarding your data, consider replicating your main database and point your reports/dashboards to that.

A common naming pattern:
ProductionData -> ProductionData_BI

This way you avoid things like deadlocks from long running reporting queries. Those can prevent you from adding new production data. It also supports the idea of separation of responsibilities.


You mean if data is moved from one db to another?

Using the same database for production logic/data storage and reporting can cause issues. This link does a good job of explaining the concern and some strategies:


Thanks, I appreciate help.
I am not moving a DB or using an ETL.

I am trying to find out, how does one know when something should be developed in Power BI or in Ignition?
Or at least what are good indicators?

I never use Power BI, so I don't know what applications are more suited to it.

Near Real Time would probably be sub-second or maybe every few seconds. If they need the display to update that quickly then an analytics or reporting tool such as PowerBI probably isn't the right choice. If they do want PowerBI to update that quickly then the database and PowerBI is going to need some very careful design.
If PowerBI is polling the operations database that is controlling equipment then you would want to be very careful that it did not interfere with operations (e.g., slow the database down, deadlock a table, etc.).
So if you want a Near Real Time display and you need to maintain control of the production system then you probably want to do that in a SCADA system.

Who in the organization would naturally own the report? If the other team would naturally own the report, they are self sufficient with PowerBI, the users in the organization are used to getting reports and analytics from PowerBI, and a 30 or 60 second response time is acceptable then PowerBI is probably the right answer. You will need to ensure that their queries do not interfere with operations. Generally that is done with a separate database.

1 Like

I would say, with the Perspective module, this becomes even more challenging of a discussion as Perspective provides the user access to what I would normally call an operations focused environment, whereas, Power BI is focused on the other business users (i.e. Accountants, Marketing, etc...). I'm not a huge fan of Power BI, but it's advantage comes in, as others have mentioned, in getting these key production parameters to a DB or data lake to keep from disrupting the production side of things. From a security perspective, this also makes sense. Now, I think Power BI has some advantages in it's ability to chart, filter, and export data from what I can tell. If you were rolling Ignition at multiple sites for a larger enterprise, these data can be aggregated into a single database, and where I think it shines better is it's native ability to filter data and redisplay it. It feels like it has some advanced PivotTable like features if you have ever used that in Excel. If you are displaying basic graphs or tables of data, then likely not something more advantageous. However, Power BI does allow business users to take the raw data and build their own dashboards without involving people with high caliber skill sets like those of us in this forum. Now, I've seen some impressive customizable dashboarding tools with Perspective, but I don't know that they are ready for 1,000 or more users served by a cloud service. Just my 2 cents.