Forum Discussion

nitishsh91's avatar
nitishsh91
Icon for Solution Supplier rankSolution 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

     

     

     

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
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

 

 

 

nitishsh91's avatar
nitishsh91
Icon for Solution Supplier rankSolution Supplier
4 years ago

Thanks.

Yes all pre-requisites ae installed on user's machine, I will raise a ticket.