Forum Discussion

dobregon's avatar
dobregon
Impactful 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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi dobregon ,

 

As described in the document,disabling Export Data also prevents users from using the Analyze in Excel feature, as well as using the Power BI service live connection.

However, if the data export function is limited in desktop when publishing reports, it is invalid to enable the export function in service.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#set-the-export-options 

 

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

  • dobregon's avatar
    dobregon
    Impactful Individual
    6 years ago

    Thanks V-lianl-msft  and lbendlin for the replies

     

    As i want to understand is why export data affect to analyze in Excel. I want to have a file connected to my olap cube (analyze in excel for a dataset) and i want to know where i need to put the group of contacts

    Doing some trials i know (and correct me if im wrong).

    • if a user want to use my file and play with the values of the olap cube, he needs to be as "built" user in the dataset.
    • Also, he needs to apear in the analyze in excel tenant permissions (or in the total organization)

      Do he needs to be appear in the export data too? 

    Regards

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

      Hi dobregon ,

       

      After my testing, you also need to enable export data for the entire organization or a specific security group.Otherwise, you cannot see the button of Analyze in Excel.


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

      • dobregon's avatar
        dobregon
        Impactful Individual
        6 years ago

        V-lianl-msft  thanks for the reply

        Another question if it is possible. If someone with security permisions (exportdata and analyse in excel) download the analyse in excel and send by email to another user in the company. 

         

        The new user doesnt need to go to the powerbi and download the analyse in excel becasue he has received it by email or saved in a folder, etc. This "new" user need to be in Export data to use and refresh the info in the excel or only in Analyze in excel? or it is better to include every people in both (export data and analize in excel) in order to they can play with the excels connected to the dataset?

        Thanks and regards!