Limitations in Power Query Online?

[tswm00]

Hi all!

I am trying to move a lot of work done in Power Query Desktop (Excel) to Power Query Online and while testing this I experiance some limitations.

E.g. Expression.Evaluate(#shared) does not return correct values for defined queries and parameters.

Works fine in the desktop version.

Is there anywhere defined what limitations apply to the Power Query Online and also of these limitations are permanent or temporary?

If limitations are temporary I can live with it and migrate to Power Query Online, but if permanent I need to change a major part of the design which will be quite an effort....

Grateful for any light on this!

[tswm00]

Thanks @ImkeF ! Will dig down in your suggestions and see if I can reach serendipity 🙂

[ImkeF]

Hi @tswm00 ,
unfortunately this is a general problem with PQO (see: Alternative calling function with text string (microsoft.com) ).
But this function might help with the conversion: Automatically create function record for Expression.Evaluate in Power BI and Power Query – The BIcco...