Forum Discussion
Dataset as Table in Excel
I have all my PowerBI Datasets setup pretty good from a security perspective and would love for my end users be able to analyze all that data in an Excel Table and not a Pivot
Hi jeffprandall ,
Check this option in the desktop and let the user export the data to a CSV file.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe I am missing a step but everytime I try "Analyze in Excel" it opens Excel directly into a PivotTable and not just a normal table. I don't want to have to create a Table in PowerBI with all the data and then have the users "Export data". Thats ugly and not easy for end users.