search

gsimardnet / PowerQueryNet

Run M Language (Power Query Formula Language) from anywhere.
MIT License
189 stars 32 forks source link

Merging queries #16

Open JaviOrdi opened 3 years ago

JaviOrdi commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

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:

image

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

Thanks.