Forum Discussion
Export underlying data option disabled in Table Visual
Hi basirve ,
Please select Allow end users to export both summarized and underlying data from the service option from the Power BI desktop.
In the Service:
-
Export using Underlying data won'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.
-
-
Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.
Please refer to the doc:
Export data from a Power BI visualization - Power BI | Microsoft DocsHope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
I would like to see export option In edit mode ... option(but this solution is not good for end users).
Hi basirve ,
Please select Allow end users to export both summarized and underlying data from the service option from the Power BI desktop.
In the Service:
-
Export using Underlying data won'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.
-
-
Export using Underlying data won't work if you enable the Show items with no data option for the visualization Power BI is exporting.
Please refer to the doc:
Export data from a Power BI visualization - Power BI | Microsoft Docs
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.