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

 

  • StelaP's avatar
    StelaP
    Frequent Visitor
    2 years ago

    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?