Forum Discussion
Dataflow - currently not as capable as PBI Desktop Power Query?
Hi Alex_Rajkov,
#1, Nope, I haven't found a document mentioned performance difference between local machine and azure service.
Query performance are based on device resources, if these functions not have enough resource, it may not better than local machine who has great resources.
As you said, data flow functions still in preview, so I think azure service only share a part of idle resource for use and test on these features(without any optimization on them).
If this is a case, it obvious not has better performance than another services who has standalone resource and particular optimization.
#2. Actually they are different type things, you can take a look at below link to know the difference between them:
Difference between PowerPivot, PowerQuery and PowerBI
#3, Did you test to customize steps in power query? If this is a case, please try to convert them as same type before compare them.(e.g. Date.From, DateTime.From)
Regards,
Xiaoxin Sheng
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.
