topic Re: How to export data from a visual (having workspaceid,reportid and visualid) without embed the re in Developer

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

Anonymous — Fri, 24 May 2024 07:45:25 GMT

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

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

lbendlin — Sat, 25 May 2024 01:18:30 GMT

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.

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

Anonymous — Mon, 27 May 2024 07:15:08 GMT

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.

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

Anonymous — Mon, 27 May 2024 07:18:20 GMT

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?

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

Anonymous — Mon, 27 May 2024 08:55:49 GMT

@lbendlin Thanks for your contribution on this thread.

Hi @Anonymous ,

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

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

Anonymous — Mon, 27 May 2024 09:18:28 GMT

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?

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

lbendlin — Mon, 27 May 2024 10:51:46 GMT

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

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

Anonymous — Wed, 29 May 2024 07:53:19 GMT

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?

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

lbendlin — Wed, 29 May 2024 11:12:42 GMT

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.