Forum Discussion

StelaP's avatar
StelaP
Frequent Visitor
2 years ago

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.   
Need Help
tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

StelaP 

  • 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