Forum Discussion
Solved
Limitiations in datamart/Power Query Online
Hi! I have built a rather complex system using Power Query Desktop (Excel) which is to a large extent based on parameters stored in an excel workbook table. I would like to migrate this system to D...
You're indeed better off trying to do this in dataflows rather than datamarts. Google your error about dynamic data sources, you'll find plenty of discussions about how to rewrite your function so that it works in PQO (at which point that code should also work in the desktop if you copy/paste it back there).
otravers
Community Champion
Community ChampionYou're indeed better off trying to do this in dataflows rather than datamarts. Google your error about dynamic data sources, you'll find plenty of discussions about how to rewrite your function so that it works in PQO (at which point that code should also work in the desktop if you copy/paste it back there).