Forum Discussion

Alex_Rajkov's avatar
Alex_Rajkov
Advocate III
7 years ago

Dataflow - currently not as capable as PBI Desktop Power Query?

Hi, I am testing dataflow. Trying to migrate my common datamodel from lots of redundant PBI files to the centralized dataflow service. Great and much needed feature!   Knowing its still in previe...
General Comment
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Alex_Rajkov,

 

>>Is the later capable of defining / referencing parameters, functions and so on?

Based on my test, it is possible to create function in data flow but it seem not recognize it as a valid function and you can't use it in other query.

 

>>The matching keys are of the same data type. I will continue to test and will isolate the step and remove all unneeded columns.

I'm not so clear for this, can you please share some sample data for test?

 

Regards,

Xiaoxin Sheng

mllopis's avatar
mllopis
Community Admin
7 years ago

You should be able to define M functions in PQ Online by editing the M code (i.e. via Advanced Editor). However, the experiences for function authoring are much richer in Power Query Desktop. You can expect over time Power Query Online will get to parity with Power Query Desktop (incrementally). 

 

Thanks,
M.