Forum Discussion
Post ProdigyService asking for Sharepoint credentials on dataset refresh, no errors when refreshing in Desktop
I'm getting this error on one of our datasets when I'm trying to refresh it via the service:
I have read/write access to the Sharepoint group and the file I'm pointing to. When I'm refreshing the file from Desktop, the refresh goes off without problems. Also, the screenshot above explicitly says that "admin has granted access, credentials are not required" - why am I then being asked to update my credentials?
9 Replies
olimiloHi Anonymous No changes have been made to the gateway. All of our dashboards/datasets apart from this specific one is having this issue. The other datasources in this dataset are working fine.
- v-luwang-msft
Community Support
Hi olimilo ，
If this is the first time you are going to refresh the data online, you will need to hit on "edit credentials", since the ones stored in your pbix files wont have effect on power bi online.
And you could read the following article:
Power BI: Two Way To Get Data From SharePoint List / Library
Best Regards
Lucien
- olimilo
Hi Lucien, there's no Edit Credentials button/link as you can see in the screenshot.
- v-luwang-msft
Hi olimilo ，
Have you configured datasource by gateway ?
Detail steps refer :https://www.axioworks.com/2018/07/how-to-publish-sharepoint-data-to-power-bi-using-the-enterprise-gateway/
Wish it is helpful for you!
Best Regards
Lucien
- v-luwang-msft
Hi olimilo ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
