Forum Discussion

tiffblue12's avatar
tiffblue12
New Member
4 years ago

Power BI Merge SharePoint Lists with Contains

Hi, I have 2 SharePoint Lists 1. Accounts  (with AccountNumber column has single Account Number for each row i.e. 22) 2. Cases (with AccountNumber column has multiple Account Numbers for each row ...
Need Help
ChristianDGreat's avatar
ChristianDGreat
Icon for Resolver I rankResolver I
4 years ago

Connect to your two sources first, the go to Power Query and do a merge.

 



Other option is outside power query, basically if your on Power BI Desktop you can just use relationship to join the two.

 

Thanks

Chris