Forum Discussion

nitishsh91's avatar
nitishsh91
Solution Supplier
4 years ago
Solved

User not able to use Analze In Excel

Hi,   I have got stuck with a weird issue with Analyze in Excel where in I am able to use the DataSet in Excel but when user is trying to do the same he gets below error:   He has got Admin...
Data Protection
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi nitishsh91 ,

     

    Is your user unable to use Analyze in Excel only for this dataset, or for all datasets?

    If it fails for all datasets, please check his excel version, Microsoft Analysis OLEDB Provider version and .NETFramework version.

    If it fails for only one dataset, please check the user's access to the underlying dataset (e.g. whether the user can create new reports with this dataset).

     

    If the problem still cannot be resolved, please submit a ticket, and it is free for pro users.

    How to create a support ticket in Power BI 

     

    Best Regards,
    Winniz

     

     

     

AnkitKukreja's avatar
AnkitKukreja
Super User
4 years ago

Hi nitishsh91 

 

The error seems to be for the datasource, can you ensure the user has same acess on this datasource and the dataset that you're using?

 

nitishsh91's avatar
nitishsh91
Solution Supplier
4 years ago

Yes user has same access on dataset and datasource, also this datasource is refreshed via on-premises gateway so I am not sure if datasource access will matter here.