Forum Discussion

rswami_4's avatar
rswami_4
Icon for Helper I rankHelper I
10 years ago

Power BI Dashboard table export to excel does not work

I am able to right click on the report and export my table.  However, when I try the same from the dashboard table that was created by using the "Pin Live Page" link, I get a blank output in excel with the following text:

 

© 2016 MicrosoftMicrosoft account symbol
Terms of use Privacy & Cookies  

 

Is anyone else getting the same error?  Any idea how to make this work?

 

Thanks,

Swami

Need Help
Tips and Tricks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    rswami_4 I don't even have an option to export data from a "pin live page" tile...

    And I am not experiencing any issues exporting to excel.

    What version of Excel are you using? And what am I missing with trying to reproduce?

    • rswami_4's avatar
      rswami_4
      Icon for Helper I rankHelper I
      10 years ago

      Perhaps I did not explain the issue clearly.  I have a dashboard created oiut of a report page.  Both the dashboard and the report from which it was created have a table.  

      The first problem is:  When hover over the table in the report (online), I get the menu on the top righthand side with the 3 dots to export data (screen shot below).  I do not see this menu in the dashboard view.

       

      The second problem is: in IE11, I can right-click the table and a option shows up to download the table into excel (Export to Microsoft Excel).  When I use this option, I get the following error with both the report and the dashboard:

       

      With Microsoft Edge and google Chrome however, I do not see the option to download to Excel when I right-click the table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        rswami_4 Ok, for the first issue. Report visuals are not the same as dashboard tiles. When you publish that visual, think of it as a new object on the dashboard. In the report, when you click the "..." the only option you see is "Export Data". You do have the same "..." on the upper right of the dashboard tile, but there are more options since it is a different object. The page icon with folded corner 

        is "Export Data"

        2nd - The export data behaviour you are describing and what I've tested is the right click functionality of the browser page, not a prompt in Power BI. If you are looking to export data, I would recommend using the methods to do so within the application.