Power BI Underlying Data Export Issue

[StelaP]

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. 

[StelaP]

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

[tharunkumarRTK]

@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-d...

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]

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?