cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GTPowerBIUser Regular Visitor
Regular Visitor

Export Underlying Datasets all set to allow - but user not able to download underlying

Ive set allow users to download underlying datasets in the following places:

1) Settings on app.powerbi.com for the report within the workspace that the dashboard lives in

2) From the desktop version of the dashboard: File/ Options & Settings/ Options/ Current File - Report Settings


However, an enterprise user (that doesn't have a power bi pro license - my firm has a premium license) is unable to download the underlying dataset from the web.


He is accessing the dashboard from the dashboard tile (clicking on the dashboard tile to access the report).


Does anyone know what else I should check or what could be going on?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Export Underlying Datasets all set to allow - but user not able to download underlying

Hi @GTPowerBIUser 

 

1. Please kindly make sure you've enabled the option under setting:

2.PNG

2.  Underlying data option is available in Power BI service when the visualization in a report has an aggregate (one example would be if you changed Count to average, sum or minimum), you probably need the aggregate column to work on it.

3. 

>>>Export using Underlying data will not work if the data source is an Analysis Services live connection and the version is older than 2016 and the tables in the model do not have a unique key.

>>>Export using Underlying data will not work if the Show items with no data option is enabled for the visualization being exported.

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Export Underlying Datasets all set to allow - but user not able to download underlying

Hi there

Does the user get an error or not the option to download the underlying data?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Community Support Team
Community Support Team

Re: Export Underlying Datasets all set to allow - but user not able to download underlying

Hi @GTPowerBIUser 

 

1. Please kindly make sure you've enabled the option under setting:

2.PNG

2.  Underlying data option is available in Power BI service when the visualization in a report has an aggregate (one example would be if you changed Count to average, sum or minimum), you probably need the aggregate column to work on it.

3. 

>>>Export using Underlying data will not work if the data source is an Analysis Services live connection and the version is older than 2016 and the tables in the model do not have a unique key.

>>>Export using Underlying data will not work if the Show items with no data option is enabled for the visualization being exported.

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

GTPowerBIUser Regular Visitor
Regular Visitor

Re: Export Underlying Datasets all set to allow - but user not able to download underlying

There isn't an error, the option for underlying data is greyed out.

Community Support Team
Community Support Team

Re: Export Underlying Datasets all set to allow - but user not able to download underlying

Hi @GTPowerBIUser 

 

Please kindly check my answer whether it works. if it does, please kindly mark it as a solution to help others find it more quickly, thanks a lot!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)