Forum Discussion
Dataflows: Import from Sharepoint folder
I'm doing the same workaround but haven't been successful. I'm copying every query associated to the combine method including the fx (invoke function) since the main query (Query1 - which combines all the files in the specified SharePoint folder) is breaking due to missing referenced module. Could you share here the steps you did? Did you have to copy over all the Sample Queries within Transfor File from Query folder as well?
Yeah I copied over all the queries that were automatically created by the combine files step. I seem to remember having similar issues but managed to get it working eventually somehow. Unfortunately I can't remember exactly what I did as this was a while ago :(
What it might be worth trying is not copying over the function. instead copy over the sample query that it's being created from. Once created in dataflows you can right click on it can select create function.
Also make sure that all the names of the queries are exactly as they are in your original query you built in desktop, even down to the case as Power Query is case sensitive.
I'm stuck with the "create function". This isn't coming up as an option when right-clicking on the query. Veles could you please provide a screenshot?
Had a look and I can't see it on the menu either.
It looks like I have copied over the "Sample File" parameter and then the function itself from what was created automatically in Power BI Desktop.
