Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 long.
SQL Profiler would be the tool to check the events that are happening. But we can't get it working in this PaaS environment. We used SQLServer, DAX Studio and Azure Data Studio.
So how can I trace query execution, capture events in a PaaS environment?
Really hope someone has the answer
regards Ron
Hi @PowerRon,
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)
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.
Hi @amitchandak
The solution you provide doesn't work with Azure SQLDB
SQL Server Profiler and SQL Trace are deprecated.
They say for Azure SQL Database you should use Extended Events to capture the queries as far as I know understand. Never used these extended events.
@PowerRon , Not very cleat
refer
Power BI Premium - XMLA Endpoint - Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI
Power BI Premium - XMLA Endpoint - Using SQL Server profiler: https://youtu.be/Xz83LBgl0Cs
Using XMLA endpoints to change data sources in a Power BI dataset
https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-d...
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |