Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Export CSV data from a visual with separated underlying model

I am struggling to understand how I can export to excel the exact data showing in a table visual from the powerbi service. I am able to use the Analyze in Excel button on the Semantic Model itself and view all the data. But I have a separate report with visuals which I want to be able to export the data from. When I try to use Analyze in Excel on the report, it returns a blank csv. 

 

It looks like there is also an export to .csv option for visuals that have been added to a dashboard, is this not an option from the report itself (in an app for example)? And when I click the button it again downloads an empty csv.

 

Ultimately what I want is for a report user to be able to download the data from a selected visual only (not the entire model) and look at it in excel. Any insight would be greatly appreciated!

  • Use "Excel with live connection".  That will run the same DAX query as the one that is used to render the visual.

1 Reply

  • Use "Excel with live connection".  That will run the same DAX query as the one that is used to render the visual.