Forum Discussion

Paramjit's avatar
Paramjit
Icon for Helper II rankHelper II
4 years ago

Full outer join between two datasets in Power BI Report Builder

Hi Team,     We have a requirement to create Full outer join between two datasets in Power BI Report Builder.   ( We need the full outer join to compare the data from two different databases.) ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Paramjit , if dimension values are missing power bi shows that fact value with null dimension value.

 

Use a measure with +0 it should do both left and right

  • Paramjit's avatar
    Paramjit
    Icon for Helper II rankHelper II
    4 years ago

    Amit

    It is for Paginated report. I have two datasets and need to join both the datasets.

    There is a lookup function but it is not fullfilling the requirement. as it does not work for Full outer.

    Is it possible to create full outer in Pagianted report.

    • Paramjit's avatar
      Paramjit
      Icon for Helper II rankHelper II
      4 years ago

      amitchandak 

      It is for Paginated report. I have two datasets and need to join both the datasets.

      There is a lookup function but it is not fullfilling the requirement. as looks like does not work for Full outer.

      Is it possible to create full outer in Pagianted report.