Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 months ago

Incorrect DAX Query Generation for Export in Embedded Power BI Reports

Hello everyone,   I'm currently working on a use case where I have to export the tabular report data from an embedded Power BI report. But currently, we are unable to generate correct DAX queries ...
deepa_deshpande's avatar
deepa_deshpande
Regular Visitor
7 months ago

Thanks Anjan Kumar. The default export functionality of Power BI is not good enough for our reports because many of the reports need to export more than 150K rows. 

 

In our organization, Report Builder is not allowed.

Power Automate scripting will not work either: Due to the dynamic selection of the fields (using field parameters), users can select any set of fields. Writing a Power Automate script for such use case is becoming very complex. 

so we are looking for the best recommended approach. 

 

Is there any way to extract (not generate) the DAX query that the report uses?

lbendlin's avatar
lbendlin
Super User
7 months ago
Is there any way to extract (not generate) the DAX query that the report uses?

Reports don't use DAX queries. Report visuals do use DAX queries. In a standard environment you can see the DAX query for each visual by using the "Export... Live connection" option and then examining the table query. But this may not be possible in an embedded scenario, and it is a manual process anyway.

  • v-achippa's avatar
    v-achippa
    Community Support
    7 months ago

    Hi Anonymous,

     

    Thank you lbendlin for the response.

     

    Currently there is no supported way to extract the DAX query that the report uses. If this capability is critical, please submit feedback through Microsoft’s official feedback channels.

     

    Thanks and regards,

    Anjan Kumar Chippa