Blending Data From Different Sources

[iqb]

We have multiple Firebase projects. In these projects we datasets. We get data using,

select * from `project1.dataset1_xxx.events_%`

select * from `project2.dataset2_xxx.events_%`

In Google Data/Looker Studio we have something called Blend Data(Get Data From Multiple Tables), does Power BI support this?

[Anonymous · Accepted solution]

Hi @iqb ,

Please try Crossjoin()  dax function.

For more details, you can read related document: CROSSJOIN function (DAX) - DAX | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.