Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power bi connection with ODS

Hey,

 

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

  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      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?