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...
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.