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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello, I came across your post recently as I have been trying to figure out the same issue and can't figure out how to get past the forbidden error message when trying to refresh my pivot table from power BI. I don't want to have to create a brand new "analyze in excel" file because I have a bunch of different views saved. I want to just be able to refresh my current pivot tables. You mentioned copying over the connection string. Can you explain in greater deal how to do that? Thank you!