Hello PowerBI team, It would be appreciated if we could export the entire data set with the charts and graphs that we have placed into PowerBi through the Analyze in Excel function. As of now wh...
Intrepidtravels
4 years agoNew Member
Hello v-robertq-msft,
To clarify, I was speaking about the powerbi online function of Analyze in Excel as shown in the below screenshot.
When this is selected for users who were provided access to the report, it pulls it out into a blank sheet with a pivot table on it with nothing in it(second screenshot).
The users can then bring back the data into the pivot table and essentially recreate the whole report, or they can individually export all of the graphs into different excel sheets and then combine them per the third screenshot.
The provided solution would be a good way to provide all the users with seperate PBIX files but, does not involve an excel based solution.