Power bi connection with ODS

[Anonymous]

Hey,

How do we connect files in Oracle Data Source directly to power bi?

[Anonymous · Accepted solution]

Hi

Do you mean Connecting oracle database? You can use oracle conenctor in Power BI.

Home->Get data - > Database ->Oracle Database

You need to make sure that Oracle driver uses 64 bit if you Power BI is 64 bit installation.

Thanks
Raj

[Anonymous]

problem is that his sourse exports in ODS which is not compatible with Power BI. Is there a way you can convert the data from ODS to XLS automatically?