Forum Discussion
Exporting Data into Excel
Dear All, My manager is asking the reports of Power BI in Excel for Users and All users need the reports in excel now there are two problems first when i am trying to summarize way to exp...
jairoaol
Impactful Individual
Impactful IndividualWhen you export to excel it takes you to the table that makes up the visualization (table or graph), but NOT the totals.
the best thing you can do is use the analyze functionality in excel.
to do this you must be licensed by Power BI PRO. Already connected to excel, you can create the dynamic tables and graphs you need, and you can make use of columns and measures from the Power BI data model.
you even respect security at the role level.
all users you share excel to must have Power BI PRO to be able to streamline and update the data.