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!
