Forum Discussion
Dataflow - currently not as capable as PBI Desktop Power Query?
QHi Anonymous,
thank you for taking the time to look at this.
#1: yep, I guess I just have to be patient...the reasons for reduced capacity in the preview status are reasonable. I just think it is worth to mention the issues right now while the PBI team is developing the feature. It could help.
#2: yes I am well aware of the different tools. I am speaking of Power Query capabilities IN PowerBI Desktop,vs Power Query Capabilities in Power BI Service / to be exact in DataFlows.
Is the later capable of defining / referencing parameters, functions and so on?
#3: The matching keys are of the same data type. I will continue to test and will isolate the step and remove all unneeded columns.
KR Alex
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
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.
