Forum Discussion
Sharepoint Folder access via Dataflow
Hi colleagues! I'm trying to move PowerBI Desktop DataSources to Power BI Service Dataflows. The best way I found is just coping scripts of Anvanced Editor in Desktop's Query Analyzer to Service's Q...
This is only relevant if you have a power bi dataflow that’s pulling from a sharepoint folder (if not you can stop reading now).
In the last 24/48hours Power BI have changed something which means all power bi dataflows that are pulling from folders will break. For some reason one of the automatic steps “Filtered hidden files” is now causing an expression error. It’s a relatively simple fix :
- Delete the “Filtered hidden files” step in the main query AND in the helper queries (the ones in the little folder) too.
- Go to the “Removed other columns” part of the query that preceeds expanding the data. Expand the data again, the new step will be called “Table.ExpandTableColumn" and you can then delete the old expand data step “Table.ExpandTableColumn”.
It should all work and refresh properly after that if your problem was anything like mine.