Forum Discussion
Power BI Underlying Data Export Issue
Please help in this problem:
I have an admin rights but I can't to download underlying data. "File Format" option is greyed out.
The file that is exported has empty rows.
3 Replies
Export using Underlying data doesn't work if:
the version is older than 2016.
the tables in the model don't have a unique key.
an administrator or report designer has disabled this feature.
you enable the Show items with no data option for the visualization Power BI is exporting.
or please check if your scenario is falling under any of the limitation documented here: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop#considerations-and-limitations
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you for the reply.
I had checked the above thread and it wasn't helpful.
The version is 2024, I am the administrator, show items with no data is not enabled.
How can I make sure that my tables in the model have a unique key?
There are several posts like this one where the issue is the same and they are unsolved:
https://community.fabric.microsoft.com/t5/Service/Underlying-Data-Shows-No-Data/m-p/817997
