Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Codecheck's avatar
Codecheck
Regular Visitor
4 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have been having the same issue with expanding columns causing refreshes failures in the dataflow. Not limited to editor and author, but rather any record field. Unfortunately the data in these records is of importance, so they can not be removed/ignored. After a lot of troubleshooting I have found the below work around to be succesfull in this scenario.

Instead of expanding the column to obtain the fields required rather create a new custom column linking to the column with data required using the below formula:

 

Record.Field([InsertColumName], "InsertFieldName")
 
In your scenario the field would be somthing along the lines of "EMail"