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.
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
- lbendlin
Super User
Is this an on-premise sharepoint or sharepoint online? In the first scenario you will need to use a gateway.
