How to export data from a visual (having workspaceid,reportid and visualid) without embed the report

[Adit_Srivastava]

Anyone knows how to export data from a visual (having workspaceid,reportid and visualid) without embed the report?

[Anonymous]

@lbendlin  Thanks for your contribution on this thread.

Hi @Adit_Srivastava ,

Base on your description, it seems like you want to export the data from the visual in Power BI Service. If yes, you can refer the following official documentation to get it:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards

[Adit_Srivastava]

It is exporting data from frontened, but i need to do via code and without embedding the report as well, so is there any possibility to do that?

[lbendlin]

If you only need the data then copy the DAX query for that visual from the Performance Analyzer and run that DAX query with your XMLA tool of choice.

[Adit_Srivastava]

We will be needing data lying behind the visuals however we were not able to use performance analysers as we are using only powerbi online. Is there any other suggestions to achieve our requirement?

[lbendlin]

Click the ellipsis on the visual. Export Data. Excel with live connection. Right click in the result. Table... Edit query. Grab the DAX.

[Adit_Srivastava]

We are trying to do the export data part itself progrmatically since we don't have access to export data via frontened, so is there any other suggesstion? 

[lbendlin]

Talk to the developer of the semantic model. Remind them that their job is to help you get insights from the data, not to prevent you from getting stuff done.

[Anonymous]

What is DAX query? Where will we get it? Could you please explain in detail along with screenshots as we have access to power BI online only.