Forum Discussion

Emrecan's avatar
Emrecan
Icon for Helper I rankHelper I
4 years ago
Solved

Reassigining columm values from another table /Merge, lookup or relations ?

Hello PBI community We have encountered a performance challange while converting one of our Excel reports to Powerbi.    We have two tables sourced from salesforce and Oracle database (Thru a quer...
Need Help
Show and Tell
  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    4 years ago

    Hi Emrecan,

     

    Have you tried to have the join done in SQL? 

    i.e. write the SQL, do the join in "WHERE"

     

    This should help avoid calculations done in Power BI. 

     

    Regards

    KT

     

Emrecan's avatar
Emrecan
Icon for Helper I rankHelper I
4 years ago

Hello KT_Bsmart2gethe 

sadly the salesforce table is currently unavailable on oracleDB and it is obtained using powerquerry connection as such we cant join the tables in SQL.Another team is currenctly trying to deposit salesforce data in oracle but we have no access to their progress

 

 

  • KT_Bsmart2gethe's avatar
    KT_Bsmart2gethe
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    If that's the case, maybe you can add Table.Buffer() to the reference table.