Scheduled Refresh is not working, only on demand

[ryanm90]

Hello,

We recently had a file that was corrupted and we were unable to recover the file. We had to create a new file and when changing the reporting over to the new file, the scheduled refresh option is not working. On Demand refreshes work, but the scheduled refreshes keep failing. It says the credentials are wrong. I have tried changing the credentials in Transform Data > Data Source Settings > Edit Permissions but It is still not working.

Additional Info: The file we are reporting off of is in my companies Sharepoint.

[v-deddai1-msft]

Hi @ryanm90 ,

Do you connect to on-premises SharePoint list or SharePoint online? If you use on-premises SharePoint list, please use Windows authentication in Power BI Desktop, then re-publish PBIX file to Power BI Service and set schedule refresh with gateway.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anand24]

Hi @ryanm90 ,

You will need to change the credentials from Power BI Services > Dataset Settings and not in your pbix file.

Scheduling automatic refreshed are functioned in Power BI Services and hence you will need to achieve it from there. Also, you need to be the owner of that dataset.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[ryanm90]

I am trying to change it there and I get this message.

"Failed to update data source credentials: The credentials provided for the Web source are invalid." I am the dataset owner and the credentials are right. I'm not sure how to proceed.

Cluster URI WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net

Activity ID d1e6fe4c-72fb-4718-8326-541b3f2144b2

Request ID 8762aeb7-31c5-97bf-7666-514d7ca7ae06

[Anand24]

@ryanm90 ,

The error clearly shows that the credentials you have put are invalid. What are the credentials you are putting in desktop to properly refresh in desktop/pbix? Try the same in services.

If you feel that the credentials are absolutely spot on and still services is throwing an error, then you can raise a ticket with MS Support. Link

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn