Dataset as Table in Excel

[jeffprandall]

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

[V-lianl-msft]

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.

[jeffprandall]

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.

[amitchandak]

@jeffprandall , As far as know Analyze in excel means to access it as a dataset and that require a pivot table to be used to build analysis