Forum Discussion

jeffprandall's avatar
jeffprandall
Helper I
5 years ago

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

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    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's avatar
      jeffprandall
      Helper I
      5 years ago

      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.