Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

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
v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

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.
GilbertQ
Super User
Super User

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 Super User!







Power BI Blog

Anonymous
Not applicable

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

Hi @Anonymous 

 

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.