Forum Discussion
Power BI Service Enhancement
Question : Our organisation uses multiple connections (Teradata) in Power BI service for the Power BI reports which uses one and the same database (Teradata) and all the data sources which uses the same database is connected to one on-premise Gateway Cluster due to which there happens to be huge load on the Teradata database that slows the query and causes the Power BI reports refreshes to fail.
Can you let us know the ways to manage this without reducing the number of scheduled refreshes, that would
1) Complete the report refresh (even after refreshing for a long time) in Power BI Service.
2) Complete the report refreshes quickly.
3) Increase the query speed in Teradata.
Also please let us know if creating a new Gateway cluster and mapping the existing data sources and reports to the new cluster would solve our issue to an extent.
Hi Augustine_Paul ,
1. You can improve query performance by optimizing DAX. For more details, refer to the link: Search Results optimize DAX performance - SQLBI
2. You can monitor and optimize local data gateway performance. You can optimize performance by streaming data or excluding specific files from antivirus scanning. For more information, refer to the document: Monitor and optimize on-premises data gateway performance | Microsoft Learn
3. You can adjust gateway performance based on server CPU. Adjust gateway performance based on server CPU | Microsoft Learn
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Augustine_Paul ,
You can check for incremental refresh possibilities.Create 2 dataflows.dataflow1 -past 2years data , dataflow 2-current year data incremental refresh and you can combine the data on semantic models.If you have a premium workspace then you can check the partition refresh on semantic models.
https://medium.com/@yukithejapanese/introduction-to-the-xmla-endpoint-in-power-bi-76448a6c9216
Thanks,
Sai Teja
2 Replies
Hi Augustine_Paul ,
1. You can improve query performance by optimizing DAX. For more details, refer to the link: Search Results optimize DAX performance - SQLBI
2. You can monitor and optimize local data gateway performance. You can optimize performance by streaming data or excluding specific files from antivirus scanning. For more information, refer to the document: Monitor and optimize on-premises data gateway performance | Microsoft Learn
3. You can adjust gateway performance based on server CPU. Adjust gateway performance based on server CPU | Microsoft Learn
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Augustine_Paul ,
You can check for incremental refresh possibilities.Create 2 dataflows.dataflow1 -past 2years data , dataflow 2-current year data incremental refresh and you can combine the data on semantic models.If you have a premium workspace then you can check the partition refresh on semantic models.
https://medium.com/@yukithejapanese/introduction-to-the-xmla-endpoint-in-power-bi-76448a6c9216
Thanks,
Sai Teja