Forum Discussion
Power BI dataflow from SharePoint failing
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!
Looks that way, i havn't checked to see if i can still get at the emails in a dataset rather than an a dataflow but i imagine i will be able to .
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"