Limitiations in datamart/Power Query Online

[tswm00]

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 Datamart and Power Query Online but experiance a lot of limitations when it comes to dynamic datasources (as provided från the parametertable) and errors with on prem execution (e.g. MS Access databases on a file system).

Are the limitiations expected to be permanent or is it temporary limitations in the preview of Datamart?

Rather crucial for med to undertstand to be able to decide what path to follow.

[otravers · Accepted solution]

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).

[tswm00]

Using Dataflows instead I can manage to use parameterized references to datasources (using PQ "true" parameters) and on-prem execution seems to work (e.g. Access database on lokal filesystem).

I can live with having "datasourceparameters" defined as "true" PQ parameters but it would have been nice to be able to write portable code that works in both PQO and PQD like this:

try p_pathPrislista otherwise fnGetParameter("pathPrislista")

But then the service reports "Cant save dataflow. One or more tables references a dynamic datasource" so I guess I can forget the idea of portable coce?