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
mh2587
Super User
Super User

How to automate the extraction desire data from Visual through performance Analyzer DAX Query

Hi PBI Community 
I hope you people will be great, I have a scenario, Can we make some sort of GUI in which the end user will extract the data from visual simple that we often copy the DAX Query from the Performance analyzer and then paste it into dax studio through which we are able to export the data in bulk size, I am just curious how to automate this process is there any way to make an application through which end user just have a button and click it to export the data 
My English is not good, I hope I explain the scenario well  


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



7 REPLIES 7
mh2587
Super User
Super User

@anyone


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



lbendlin
Super User
Super User

Ask the end user to export the visual's data to "Excel with live connection".  It is not actually a live connection, instead it is an XMLA connection that includes the DAX query.  You can then analyze the DAX query in the Excel connection properties. After you have the query you can create a Power Automate flow that runs it for you, and that delivers the results to where you need them.  You could even include a Power Automate visual in your Power BI report that would initiate that flow but the UX will be bad.

I know one of the most straightforward and efficient way of exporting more than 1m rows in Power BI is just to copy the DAX query from Performance Analyzer, and paste it to DAX studio and export. This works and is fast.

However, suppose my users are business users, and we want to avoid having them do these manual steps, is there a way to automate this process via a button on power bi frontend? Like in a click of a button, capture the dynamic dax query, and export?


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



But it still requires to copy the dax query from the performance analyzer and then pasting it in power automate's query against dataset body I want to automate the whole process for the end users as they are not technically sound


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



But it still requires to copy the dax query from the performance analyzer

Not from the Performance Analyzer - from the exported Excel file.  You can remove the silly TOPN filter there.

 

I think you are wasting your time focusing on the wrong problem. Your users are supposed to gain business insights from your Power BI reports, not to "fight the API"  extracting data.  If they need the source data then give them easy access to the source data.

 

 

Thanks for the suggestion will discuss it


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



mh2587
Super User
Super User

@amitchandak @Greg_Deckler @lbendlin Need help regarding the Scenario, please 


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
Europe Fabric Conference

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.