Hi,
My power BI refresh has been failing more often recently. Example of error message at bottom (changed some info, hence the 'xxxx').
I have daily files being added to Sharepoint folders in a workspace each day through a power automate flow. The files are then combined and connected to PBI tables. My daily scheduled refreshes fail quite often, moreso recently.
Each time, it specifies a different sharepoint file/folder in the error. And then sometimes on 3rd manual refresh attempt, the refresh will work. Other times, I can manually refresh in power editor ok, but then when try refresh visuals, it still won't work. Currently not able to refresh one dataset like this even with multiple manual refresh attempts. If any other things I could try.
I've tried edit/clear permissions and add credentials again a few times, but doesn't work. I've tried adding timeout=#duration... part in advanced editor, but it says there's 3 arguments where 2 is needed (kinda separate question on how to adjust);
, [ApiVersion = 15], [Timout=#duration(0,0,30,0)]),
An error occurred in the ‘Google 1_Last_30_Days’ query. DataSource.Error: SharePoint: Request failed: https://xxxx.sharepoint.com/sites/msteams.xxxx/Freigegebene Dokumente/Power BI/Data Sources/PBI Google Data/xxx Daily Report 30 Days_csv/_api/contextinfo
Details:
DataSourceKind=SharePoint
DataSourcePath=https://crealytics.sharepoint.com/sites/msteams.deichmann
SPRequestGuid=80c57c9f-d08e-b000-a25c-4568af7e9312
