AnsweredAssumed Answered

Working with Microsoft Power BI and PI AF - best practices?

Question asked by DAngevine on Dec 5, 2018
Latest reply on Oct 6, 2020 by Kenneth_Barber

Working with Microsoft Power BI and a large PI AF data set and experiencing slow performance.  We are using PIOLEDBEnt to grab the data, everything is located in the same server area (PI, AF, SQL, client in the building) and seeing slower performance across a single view fetching from a single template.  We're seeing 10+ minutes to fetch the data and it is failiing and taking down other services if concurrent users try the same fetch in too short of a window.  What is the best practice here for data caching / queries to maximize performance?