Power BI Premium Query Profiling with DAX Studio and SQL Profiler

Patrick looks at how you can use DAX Studio, or SQL Profiler, to do query profiling on Power BI Premium. This can help you debug query performance and more.

********
LET'S CONNECT!
********

***Gear***

#PowerBI #PowerBIPremium #DAXStudio

[HariharasudanP]

Q: How do we collect stats as tenant admin of enterprise across various semantic model for which users does self service in automated ways ? Log analytics or scanner/metadata API or any other options ? Semantic link ?

[sameersheik]

Hi Patric,

Can we get the list of tables participating query profiler, or any other way to get the list of tables used in a single report

[sagaon]

Just a beginner here in PowerBi :) But I like Guy in a Cube :)

[janardhana]

Hi sir, help me with this info, we are power bi pro users( we don't have, power bi premioum in our organization), qn: we still eligible to create premioum workspaces ? Is there speperate cost involved in creating/ using premioum workspaces? What is the difference between premioum workspace and normal workspace.

[sramanathan]

Hi,

When i am trying to connect to My workspace using the xmla end point, it is giving error: The specified Power BI workspace doesn't exist after i login, Is there anyway in which i connect to my workspace?

[obotaira]

Bananas! Does it only work with Power BI Premium?

[Martin-lfse]

Hey Patrick, I am trying to capture a dataset refresh performance using SQL Profiler. But I am having no success trying to connect to the dataset.
As soon as I click Connect, I get an error message:
Internal error: An unexpected error occurred (file 'pfadalwrapper.cpp', line 986, function (pfutil)
Any chance you or anyone seen this before?

[MacPaulos]

Is XMLA endpoint available for On-premise PBI? If no, does anyone know if it's coming :)

[lanetimepditty]

Made the mistake of watching this video with AirPods in… intro incinerated my eardrums 😅🦻🏻