Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
1. Please kindly make sure you've enabled the option under setting:
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.
1. Please kindly make sure you've enabled the option under setting:
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.
There isn't an error, the option for underlying data is greyed out.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.