Rebuilt OBIEE DDR Reports to POWER BI

Hi,

We have 100 OBIEE DDR Queries, we are replacing OBIEE reporting tool to Power Bi and Oracle database to vertica. As per my understanding we need to rebuild the reports in power bi.

OBIEE DDR Queries are long SQL Quires with multiple joins and where clauses, i wanted to know what the best practice will be to use these SQL Queries. Do I need to create 100 views at the backend (Vertica) to run these reports or there is any other ways to write the SQL quires directly on power BI.

We would be using the direct Query method as data size is huge.

Thanks

@Sadapa07 if you can help me here as i find a simlar post of yours where you are migrating OBIEE to Power bi. Multiple Case When statement in DAX from OBIEE