SharePoint source forgets credentials on scheduled refresh

[PetyrBaelish]

I have a report that connects to a combination of SQL Server data sources, and a SharePoint Online list.

I ma finding that the data source for the SharePoint Online list is constantly forgetting its credentials, causing the scheduled refresh to fail.

In Power BI Service, on the report settings, under gateay connection it says "Gateway or datasources not reachable". For the 3 sources that I have (2x On-Prem SQL Server, 1x SharePoint list" - I can see each are successfully mapped to a Data Source in my On-Premises gateway. When I go to manage gateways & go to the data source settings for the SharePoint source I'm getting the details "invalid connection credentials". When I select edit credentials - I select OAuth2 as the connection method, select my account and it proceeds without any further prompts, but the error doesn't go away.

From here I open my Power BI Desktop file, attempt to refresh the data and I'm prompted to sign in for my SharePoint source - it says "the credentials provided are invalid" - under the Microsoft accouint tab, I select sign in as different user, select my account, select the appropriate site collection as the level this applies to and select connect (point to note I use the same account every time). This works ok and the data refreshes (and I can see the updated refresh time for the report in Power BI Service).

So it works manually, but not automated. It needs to update every hour (and I can't do that manually). Can anyone help as to why it won't update on the scheduled refresh??

I can also confirm all privacy level settings, for all data sources, in the service and under options in Power Bi Desktop are set to Organizational.

[PetyrBaelish · Accepted solution]

The problem was some changes to MFA.

[v-yiruan-msft]

Hi @PetyrBaelish ,

Please review the solution in the following threads, hope they can help you resolve problem.

Sharepoint Data Source file Invalid Credentials in Service

Scheduled Refresh Failed - missing credentials - Data source credentials greyed out

Best Regards

Rena

[Greg_Deckler]

@PetyrBaelish So this happens from time to time on the Service, particularly with SharePoin for some reason. Probably a temporary thing. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".