Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Analyze in Excel - Forbidden error

Hi All,   I am trying to run an established excel report which has embedded Analyze in Excel Pivot tables and when I try to refresh them I am getting a "Forbidden Activity" error. I have read other...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi All,

     

    I was able to solve the issue by creating a fresh Analyze in Excel file using the same Power BI report and copying over the connection string from that file into the existing excel report. I am now able to refresh and this hasnt affected the other users. 

     

    Thanks for the help!

collinq's avatar
collinq
Super User
5 years ago

Hey Anonymous ,

 

If it works for others and not you then it does appear to be an issue with your userid.  I am not sure where the permissions issue may be though - are there mutliple data sources/files and one of them might be in a location (network share, etc) that you don't have permission to interact with and can read only?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi All,

 

I was able to solve the issue by creating a fresh Analyze in Excel file using the same Power BI report and copying over the connection string from that file into the existing excel report. I am now able to refresh and this hasnt affected the other users. 

 

Thanks for the help!