I have a dashboard that has a table tile in it that folks would like to use to export the data to Excel so they can work on it there. How can users of my dashboard export grids of data out of dashboards?

We have finally discovered the problem. My IT shop had turned off "Export Data" under the admin portal tabl "Tenant settings". If you turn that on, then the ellipsis should show up for me on my dashboard. I can't really test that until IT turns on the functionality (which could be months if not years away!) Thank you!

Downloading data from Dashboard table or matrix tiles

13 Replies

BhaveshPatel
Super User
9 years ago

Follow the steps listed below to get the job done:

Export a dashboard's data
Select the ellipses in the top right corner of the visualization.
Choose the Export data icon. The data is exported to a CSV file. If the visual is filtered, then the downloaded data will also be filtered.
Open the CSV file in Excel.
- Anonymous
  Not applicable
  9 years ago
  Thank you so much for responding! You know - those instructions work on my Power BI Desktop, but for the dashboards and reports I have published, there is no ellipses on the visualizations. I don't have Power BI Pro though, so I'm wondering if that is it. Can you download data from your published reports and dashboards on Power BI online rather than the Power BI desktop application?
  - tringuyenminh92
    Memorable Member
    9 years ago
    Hi Anonymous,
    
    If you are invididual account, please use trial pro to use that feature (i'm not sure this feature belongs to pro or not cause i'm using pro lic)
    In case your account is tentant of O365 sub, you need to check with your subscription admin to ensure that feature enabled or not
    https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-portal/ (in tenant setting)
- marcoselias
  Advocate V
  9 years ago
  Bhavesh,
  
  There are no ellipses in the top right corner of the table visualization when viewed in a dashboard. User needs to go to the report to be able to see the ellipses menu.
  - Anonymous
    Not applicable
    9 years ago
    We have finally discovered the problem. My IT shop had turned off "Export Data" under the admin portal tabl "Tenant settings". If you turn that on, then the ellipsis should show up for me on my dashboard. I can't really test that until IT turns on the functionality (which could be months if not years away!)
    
    Thank you!