Downloading data from Dashboard table or matrix tiles

[Anonymous]

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?

[BhaveshPatel]

Follow the steps listed below to get the job done:

Export a dashboard's data

1. Select the ellipses in the top right corner of the visualization.
2. 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.
3. Open the CSV file in Excel.

[marcoselias]

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 · Accepted solution]

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!

[marcoselias]

Hi Susan! Where or how do I access the admin portal to modify the "Tenant Settings"? Is this in Power BI Service or Power BI Desktop? Thanks!

[tringuyenminh92]

Hi @marcoselias,

if your account has Power BI admin or Global Admin role, you will see this option in setting option in the top right of screen

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-portal/

[marcoselias]

I see. Thank you!

[tringuyenminh92]

Hi @Anonymous,

That's it ^_^ i'm thinking in my mind: "i've told you, i've told you"

[Anonymous]

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?

[BhaveshPatel]

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/

[Anonymous]

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.

[Anonymous]

Hi @Anonymous,

I test on my side but I can't reproduce your issue, can you share some content about your issue?(e.g. data source type, connect mode)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin,

Thanks for trying to reproduce my issue.  Your post got me to thinking about how to provide more detail about my problem. I stumbled onto a technical details page which gave me a link to microsoft support. I have sent in a microsoft support ticket, so if I hear back from them, I'll definitely let you all know.  Here's the techincal details from one of my tiles.  I don't know if this helps give you more information or not.  

Tile Id6002161

Query hash-6032316830742257000

User Object Id82f9d8b4-d43a-465b-8345-1aeebd6daf18

Dashboard Id3055237

Model Id5663577

Model last refresh time12/20/2016, 1:26:41 PM

Model last refresh status0

Model next refresh time12/30/9999, 5:59:59 PM

Direct query modefalse

Is refreshed by content providerfalse

[tringuyenminh92]

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)