none
SFDC merge query multiple objects RRS feed

  • Question

  • Has anyone run into an issue with left joining multiple SFDC objects in power bi desktop?

    I'd like to join CASE, Account, User, and Product objects but it seems to fail after joining and expending the second table. 

    My steps

    • Left Join Account to Case
    • Left Join Product to Case
    • Expand Account
    • Expand Product - this is where it stops or errors out. 
    Wednesday, November 13, 2019 10:50 AM

All replies

  • Luis,

    Can you provide the PBIX / PBIT or the actual text of the query? It's not clear what exactly you are doing, and/or what error you are receiving. 

    Thanks,
    Cameron

    Wednesday, November 20, 2019 8:10 PM