1 Reply Latest reply on Dec 6, 2018 1:21 AM by Lal_Babu_Shaik

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

    DAngevine

      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?