Merging queries

[JaviOrdi]

Hi Guillaume,

PowerQueryNet handles merging queries?. Up to now, I have run one single query with no merging queries inside. Would it be possible?

Thanks.

[gsimardnet]

Hi,

Yes it is possible and there are different ways to do that. If you use the PowerQueryNet.Client library, you will need to use one the of the following methods on the Queries object : Add, AddFromFile (Excel or Power BI), LoadFromFolder (load *.pq files) That way you can add as many query as you need.

If you use PQNet cli, your "source" can be a folder where every *.pq file will be loaded or, if you prefer, you can load queries directly from and Excel or Power BI file.

[JaviOrdi]

Hi Guillaume,

Thanks. I could run successfully a query with a nested join inside. The issue I am having now is that fuzzy nested join throws the next error:

Perhaps the PowerQueryNet service is not updated to support fuzzy nested joins?

Thanks.