Forum Discussion
Credentials
Hi PBITA
You cannot refresh in Power BI Service without entering credentials in Settings=>Dataset=> Data source credentials .
So you need update your credentials then you can set scheduled refresh or refresh automatically in Power BI Service .
Sign in with your account that can access your Power BI Service .
When you update your credentials in Data source credentials ,you can see like this .
Then you can try to refresh automatically ,you can see the result in Refresh history .If it successfully ,the Status is Completed .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Hi Ailsa,
I did the steps as you show in the snapshot, however, no matter what kind of combination I chose, it failed.
For my case, the data source (excel) is stored in a company SharePoint site. I can get the updated data throughout the Power BI desktop report without a problem. But once I publish the report to Power BI Service, the dataset cannot be refreshed due to the failure of credentials.
Do you know what should I do? I am a Power BI Pro license user.
Best,
Na
Is this an on-premise sharepoint or sharepoint online? In the first scenario you will need to use a gateway.
Hi lbendlin ,
I am using SharePoint in Microsoft 365 (formerly known as "SharePoint Online"). any advice on how to fix the data source update credential issue?
Thank you in advance.
Best,
Na