What are the pros/cons of each of these options and when do you choose one over the other.
PI Vision is used to visualize operational variables over time ranges and real-time data.
Power BI is better used for statistical analyses (business approach).
It is possible to build custom symbols on PI Vision to have similar functions (getting data from PI Analysis) but it is important to balance development time and revenew before going to this path.
In general both applications are not concurrents and one should not replace another.
Business needs and costs should be evaluated as well when deciding how to visualize data. Some things that are easily done in one platform are not easily done in others. I will say that Vision does offer some middleware and vis layer capabilities that are convenient in comparison to other enterprise alternatives. Some out there are choosing to use it as a way to display a mix of real time and other data (for example, production vs. planning) that reduces the overhead and effort associated with getting at the data by other means.
If you have the luxury to do so, it is useful to trial transactions in different platforms in order to understand their capabilities and limitations. This can be instructive in a way that will be difficult to synthesize from other review methods.
For Timeseries data i would prefer PI Vision over Power BI. Power BI works well in terms of statistical data visualization but if you are looking for time series data PI Vision provides better insight to your data. I have done some work on realtime streaming from OPC UA to Cloud (IOT hub) and Power BI but PI vision provides better view compared to Power BI. If you are using Power BI for modelling and data analysis over the history using Machine learning or other models then it is best fit.
Why use one when both will do? We are using Power BI and PI AF to work with batch summary data. We created URL links that take information from the row and feed that into the URL link for PI Vision. What is really cool that plant based users with PI Vision can work with Power BI models on the cloud and the PI Vision links still work on their local server. Engineers love it. Documentation for both Power BI and PI Vision is on their respective web sites.
Retrieving data ...