Forum Discussion
Power BI dataflow from SharePoint failing
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.
Seems like we both have the same issue with dataflows and SharePoint as a result of expanding columns to get an email and are finding other ways around it. ☹️ Glad to know it is not just me!