Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Export excel or csv from published power bi

Hi All

 

I just published a power bi report and i would like to make end users who have the power bi link to the report download the excel behind some visuals (ex. tables). I have alaready clicked on "Allow end users to export data with current layout ...." (as in the picture) but when i open the power bi through the public link the three dots from where i can click on "export data" don't appear. Could yu please help me? 

 

Thanks!!

 

Data Protection
Dataflow
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Okay I see few scenarios here firstly make sure you have saved and published your report after enabling the "Allow end users to export data with current layout" option.

    Now you can Open the report in Power BI Service and navigate to the page where the visual is located.

    Click on the visual to select it. In the Visualizations pane, expand the "Visualizations" section.

    Scroll down to the bottom of the section and make sure that the "Data" icon is selected (it should be highlighted in blue).

    Now, check to see if the three dots (ellipses) appear in the upper-right corner of the visual. If they do, click on them and select "Export data" to download the underlying data as an Excel file.

     

    Note : If the above steps do not work, then it's possible that the "Export data" feature is not available for the specific visual or data source. In that case, you may need to consider using a different visual .

     

    Thanks !

    Jupsimar Singh

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi! Thanks for your reply. I saved and published the report. Once i'm on pbi service i opened the report, click on edit and from here i opened the visualization panel after selecting the table i want to enable export data option. but from here i cannot find the data icon, could you please share a screenshot of where it is located? many thanks 

       

       

      • Anand24's avatar
        Anand24
        Icon for Super User rankSuper User
        3 years ago

        Hi Anonymous ,
        You need to follow the below:
        Go to Edit Mode > Click on the visualization > Click on Format > General > Enable Header Icons > Enable more options > Save the report

         

        You need to achieve the below:

         

         

        Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

        Proud To Be a Super User !!!
        LinkedIn