Full outer join between two datasets in Power BI Report Builder

[Paramjit]

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.)

As per checking , LOOKUP function works for only inner or left joins. 

Please help.

Thank you,

Paramjit

[Paramjit]

Team can we get any help on pagianted report full outer join.

[amitchandak]

@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]

@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]

@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.