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
3 years ago

Yes agree, new excle sheet with new connection works well when we have the 1 or 2 reports, but if we have more reports then it is a tedious job to create reports. I also encountered the same issue. 

 

Change the dataset id in the excel connection properties resolves the issue. Reason for this issue given below. 

 

Scenario:

1) if there is already a dataset (namely ABC) created/publihsed in service, excel connection and reports are created on top the dataset.

2) Later, deleted the dataset and create a new dataset with the same name (ABC) still it wont connect, because the intenal dataset id differes from old and new ones. Dataset id can be seen inthe URL with GUID (next part of /datasets/----/)

solution:

Copy the dataset id from the URL and change it on the Excel connection properties of Initial Catalog (There will be a GUID here as well). Then it works..