Forum Discussion
Evaluation error in dataflow
Dataflow was working fine and then 4 additional excel files added to the sharepoint file and now dataflow evaluation errors when trying to view. Even if the added files are deleted still cannot load...
Try to avoid the nested join. Use the data model for joining or use Table.AddColumn.
There are a couple of steps you can eliminate. Refactor the code.
Also note that there is currently an issue in the Power BI service that may require a gateway for SharePoint Online sources even when they are not merged with other sources.