Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to get SQL Profiler working with Azure SQLDB?

Hi, We are having a Power BI dataset in the service. The source of this dataset are some Azure SQLdb tables. PaaS (Platform as a Service) setup. The daily refresh of this Power BI dataset takes lo...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous,

 

There are many reasons why datasets can be slow to refresh.
1 Please consider optimizing the model to increase the refresh speed. For example, remove unnecessary columns.
2 Complex or inefficient calculation logic, including RLS roles.

3 Not enough memory

4 CPU saturation

For more details you can refer this official atricles.

Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

 

Or these links maybe helpful.

SQL Server Profiler in Azure Data Studio (sqlshack.com)

How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user is different from logged in desktop account? - Stack Overflow

 

 

Best Regards

Community Support Team _ chenwu zhu

 

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