Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

export data to excel

Hi all,

 

My first post in the community,

 

I used to be able to export data from my visualization to excel on the browser edition as indicated on https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/.

 

Recently, I have not been able to do so.

 

.

 

I have tried on different visualization, but everyone give me the ellipses option, and those visualization that give me the ellipses option do not give me the option to export.

 

Can anyone help me out?

 

Thanks in advance.

 

 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi Anonymous,

     

    Since you have tried on different visualizations, maybe "export data" was disabled by your Power BI admin.

    >>Power BI admins have the ability to disable the export of data.

     

    There are some limitations with "export data". Could you please create a very simple visual to test?

     

    Best Regards!

    Dale 

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    Since you have tried on different visualizations, maybe "export data" was disabled by your Power BI admin.

    >>Power BI admins have the ability to disable the export of data.

     

    There are some limitations with "export data". Could you please create a very simple visual to test?

     

    Best Regards!

    Dale 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Dale,

       

      Thank you for the quick response.

       

      I have read the limitation with "export data" as indicated on https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/, and have tried to construct my data to make the exportation possible.

       

      However, it does not seems to work:

       

       

      I will try to contact my Power BI administrator to see whether they have disable the option and will return to this post ASAP.

       

      • cwoo's avatar
        cwoo
        Regular Visitor
        8 years ago

        Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.

         

        This is one of the limitations of the export stated in the documentation .  So does this mean that and measure in a report like  

        CALCULATE (TOTAL SALES); SAMEPERIODLASTYEAR( DATE)  will not be able to export. 

         

        I tried it for a table and  the column  does not add up in the spreadsheet. 

         

        Further  if i export from the desktop version it does not export all records . I have to  go to BI service  in cloud to export  and all the records  are exported but the CALCULATE (TOTAL SALES); SAMEPERIODLASTYEAR( DATE)   does not add up in the  exported excel  spreadsheet .

         

        Can any  person assist.   So then  how do you get this data to a spreadsheet ? if the export does not  work .  I dont seem to  have this problem  for tableau

         

        colin 

         

        Colin 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Dale,

       

      You were right. My organization's Power Bi Admin had a restrain on "export data", which now has been uplifted.

      The reports that I administrate can now export data as before.

       

      Thanks your help.