Forum Discussion
Unable to refresh web data source in PBI Service
Hello, I'm unable to refresh a Web data source in PBI Service, which happens to be connected to an Excel file in SharePoint. Error message is (from the Service, Dataset section)… "Your data sou...
I had the same issue with web sources, but for me it helped to have the same authentication method in the PBI service as i had in the PBI when i published it.
To fix this i first changed the permisions on PBI (Go to File Menu > Options and Settings > Data Source Setting > Edit permission.
for example change it to Anonymous. Then republish it to PBI service.
After that make sure the datasource credentials in PBI service have the same permission.
Maybe this helps.