Combine multiple unions with different filters

[Elichka]

Hello, I'm new to Power bi. Need to create report using oracle query with multiple unions and different filters (where clauses).  Thanks

[Elichka · Accepted solution]

Hi Liu, I'll try, thanks a lot!

[Anonymous]

Hi  @Elichka ,

You can select Advance options when connecting to Oracle in Power BI Desktop, where you can place SQL Statements.

This is the related document, you can view this content:

How to create Select query with where clause with ... - Microsoft Fabric Community

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Elichka]

Hello, Would this solution work if i have Life connection in DeskTop? Thank you