Forum Discussion
Power BI dataflow from SharePoint failing
I have a Power BI dataflow that connects to a SharePoint list. It loads in Power Query online with no issues. It was refreshing with no issues on the service until 5/13/2022. Now even though I have d...
Hi, recently my Bi Dashboard has run into the same issue.
"DataSource.NotFound: SharePoint: Request failed (404): The remote server returned an error: (404) Not Found. (Item does not exist. It may have been deleted by another user.)
DataSourceKind=SharePoint
DataSourcePath=https://XXXX.sharepoint.com/sites/CCCC
sprequestguid=6a88caa1-e029-5000-ef5b-181e8e9945e0
Url=https://XXXX.sharepoint.com/sites/BBBB/_api/Web/Lists(guid'890f50c6-5dd9-4180-90c7-a1c46c1559f9')/Items(481)/Lookup"
I investigated throughly and can confirm that no files or items in my list had been deleted, and when i review the powerquery steps in my pbix file, I found out that this error always occur at the GroupBy step.
Can anyone help in resolving this or finding a workaround?