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 data in Power Query online, I get the error when the dataflow refreshes:
Error: 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.) Request ID: 53ca782d-9ece-9f06-8200-ae482a2a81c5 Activity ID: 181cb413-fd1b-446f-a9d5-dd4569c30929
I have verified with our SharePoint admin that I am navigating to the correct GUID in Power Query online, but refreshes fail.
Any assistance would be appreciated. TIA.
9 Replies
I have the same issue with a data flow since the 17/05/22. Checking the list ID matches the query and sharepoint, as described it runs fine in query designer and checking the credentials all seem correct.
There's about 6500 items on the list, however its been over 5000 for several months so i doubt its a list view threshould issue as those shouldnt apply to powerBI.
I feel like there was some change in SharePoint recently that is causing the issue, but I am not a SharePoint expert. In the Power Query, I expanded a SharePoint column to get the email of each record. This column exists in the Power Query editor, but not when the report or data flow refresh. I had to change the source of my report to get the refresh to work.
I was expanding editor & author to get the emails. removing those from the query allows the dataflow to refresh. of course i now have to repair 2 datasets that used those fields.
as sharepoint calls author and editor Createdby and modified by im guessing that now has something to do with it.
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?Hi
This worked for me. I used the SharePoint Online List connection. I had the same error as yourself. I cannot provide you with the techincals but if you use just the SharePoint List connection and then expand any of your data columns where there are records it causes this error. Mine in particular was when I unpivoted my data when using the SharePoint List connector, I was getting the error. I then used SharePoint Online List to connect to the same list and copied the same transformation steps and then this worked.
