Forum Discussion

Paradise80's avatar
Paradise80
New Member
2 years ago

Power Bi refresh problems

Good morning, I ask Microsoft experts for help in SQL Server on Azure and Power BI. I work for the "Corte dei conti" Public Sector client in Italy, and for about 5 years there have been Power Bi re...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Paradise80 ,

 

1.It may be helpful to view and apply some best practices to optimize SQL Server performance on Azure. This includes optimizing applications, tuning indexes and queries for efficiency, and monitoring CPU and IO resources.

2.Exploring asynchronous refresh options or adjusting the refresh rate if you're using Power BI Premium could provide some relief.

3.Try to enable automatic optimization for the Azure SQL database.

 

Please refer to the following documents for more information.

Monitor and Tune for Performance - SQL Server | Microsoft Learn

Troubleshoot entire SQL Server or database application that appears to be slow - SQL Server | Microsoft Learn

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.