Forum Discussion
Downloading data from Dashboard table or matrix tiles
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!
- 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.
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?
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)
Data can be exported from PowerBI Service as well. It has the same ellipses option in Dashboards & Reports view in PBI Service. The only data not exported is that using natural Q & A. Visaulizations prepared with Q& A does not export the data.
You do not need Pro account for this.
For more inforation, Please refer to this Reference Documentation Link.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/
I watched that link. Thank you for sending it. However, none of my dashboard visuals even have the ellipsis available. I'll get some screen shots and show you what I'm seeing.
I tried pinning just a visual to a dashboard rather than a whole report page to a dashboard. That at least gave me the ellipsis, but when I use those ellipsis, none of the choices are for exporting the data to excel. Am I building my dashboards incorrectly? I am stumped.
This first screen shot shows you how when I try to get the ellipsis on the first set list of data titled "Outages longer than 14 hours", the ellipsis don't even show up. The second screen shot shows you how when I send a single visual to a dashboard, the choices I have after hitting the ellipsis don't include exporting the data to excel.
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.
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!
Hi Anonymous,
That's it ^_^ i'm thinking in my mind: "i've told you, i've told you"
