Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PowerRon
Post Patron
Post Patron

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 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

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

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)

How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user ...

 

 

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.

 

 

 

PowerRon
Post Patron
Post Patron

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.

amitchandak
Super User
Super User

@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...

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.