Forum Discussion

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


       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi, thanks! I had a try but it seems it doesn't work. The visualization from which i would like to export data is a Table. From power bi service i clicked on edit, i selecter the table then from general > Icons > i selected only "more options". I saved it. 

        From my power bi service account i can export data, but when i published it (file >embed report > publish to web (public)), i copy and paste the link on the browser. When i see the report on the web if i click on the visual table there three dots doesnt appear. Do you know how can i solve it?

         

        Many thanks