Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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

Tutorial Requests

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        lbendlin
        Super User
        2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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?