Unable to refresh from Excel in One Drive for Business
Hi, I have a dashboard that uses dataset from excel that is stored in One Drive for Business. It worked fine until recently. I get this error when trying to refresh the dataset "it appears that your access to this file on OneDrive for Business has been blocked. Please contact your site administrator."
The same business account is used to login into the Power BI service and One Drive. Can anyone explain what's wrong?
I have been refreshing my PowerBI service reports and dashboard from an excel that I stored in my One Drive for Business. Used to work fine but now I get an error message "It appears that your access to this file on OneDrive for Business has been blocked. Please contact your site administrator."
I am using the same business account for both ODfB and Power BI. Can you help to figure out what's wrong?
Sounds like a permissions issue on the file on the one-drive folder. In the connection settings you would have set up a Username and Password that Power BI would use to access this file. I'd expect you have either:
Changed the password for that user account but not updated Power BI with the new password
The permissions have changed on the file, and this account was no longer included.