Forum Discussion
Analyze in Excel - Forbidden error
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!
Hi Anonymous ,
DO you ahve more than one set of Power BI credentials? You may be signed into Power Bi with a different set of credentials. Also, you may need a newer version of Excel (just make sure that you ahve the latest and greatest version). If this was working and "nothing changed" and now it does not work I would also wonder if your organization's Group Policy has changed, or your password has expired, or the network has been modified to have certain ports/links not to be allowed or your permissions were changed (you need to have underlying dataset permissions I believe).
Let us know if any of those resolve the issue.
Hi collinq
Thanks for posting a response! I only have 1 set of credentials so that shouldn't be an issue. My organization is not on the latest and greatest excel update, however I have collegues using the same version I have and they are able to refresh the report. I am a new user to the report so it isnt a case where it just stopped working one day. I do have access to the underlying dataset, and can freely create/use new analyze in excel files using the same source. This report was made before I was part of the company, so I am wondering if that could be an issue?
Really appreciate the help!
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?
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!