Sharepoint excel auto refresh does not work

[szlipcsei]

Hi there, I noticed that the automated refersh does not work what I linked to the PowerBI online database, so the database is not refreshed for two days now, meanwhile it says it is refreshed as attached.

Dashboard is not refreshed:

Could you please help?

Thanks, Szilárd

[szlipcsei]

Neither the manually started "Refresh now"

[szlipcsei]

And it used to work just fine and the refresh was all set and working

Thanks Szilárd

[v-haibl-msft]

@szlipcsei

Could you please try to re-enter the OneDrive credential to see if it can refresh properly then?

Best Regards,
Herbert

[szlipcsei]

Thanks Herbert. Could you please provide some guidance how to do that? I never did that and can't find it.

Thanks, Szilárd

[v-haibl-msft]

@szlipcsei

How did you get data from sharepoint, like following screenshot which through PBI Service directly? In this way, there is no credential field in dataset settings.

Best Regards,
Herbert

[szlipcsei]

Yes, correct, I directly linked an excel file on our O365 SP document library. And it's been working just fine,

both the automatic one or the manual one, but suddenly both stopped. Yesterday morning I could refresh it, but it does not work again today. I keep trying.

What could have gone wrong?

Thanks, Szilárd