Forum Discussion

PBIDEV_10's avatar
PBIDEV_10
Helper II
1 year ago

SQL join Statement to query a Power BI Dataflow

Hello everyone! I am creating a dataflow (Gen 2) based on the existing PBI datasett in import mode. So I started with importing power query template to the dataflow. I have used following code to co...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

Thanks for the solution lbendlin offered, and i want to offer some more informaiton for user to refer to.

hello PBIDEV_10 , based on your descriotion, you can user merge queries in power query, it contains left join, you can refet to the following link about it.

Merge queries overview - Power Query | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PBIDEV_10's avatar
PBIDEV_10
Helper II
1 year ago

Hello Anonymous Thank you for your suggestion but in this case Table2 is not used in dataset as a table but referred only into the join to filter rows in fact. Can I still use merge query option?

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    you need to ingest both tables separately in Power Query and then merge them (which by the way is highly not recommended - let the data model do the work for you).