Forum Discussion

dobregon's avatar
dobregon
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Export data vs Analyse in excel

Hi guys, I'm trying to understand some tenants options and i have doubts about both options. export data --> In the definition of the option "Users in the organization can export data from a ti...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi dobregon ,

     

    It is better to include every people in both (export data and analize in excel) ,because some unknown effects of the shared workbook have not been found.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

"Export Data"  is limited to the data behind an individual visual on a report page.

"Analyze in Excel" connects to the SSAS instance and gives your users full(*) access to the data model. It's like accessing an OLAP cube (a multi-table pivot).  This is much more powerful and (arguably) more convenient than Export Data.

 

*) within the limitations you as a developer have imposed by hiding columns or tables in your data model. It also requires explicit measures (something that is not absolutely necessary in Power BI)