Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am new to Power BI and I am trying to connect to a Oracle database which has a very huge data in it. I am using ODBC option to connect. I have created a DSN and using the same in ODBC. Once I select the DSN and select OK, I receive an error message saying - "Array Dimensions Exceeded Supported Range". Please help me. Thanks.
@cslarun,
Why not directly use the built-in Oracle connector and DirectQuery mode in Power BI Desktop to connect to your database?
Regards,
Lydia
Hi Lydia,
Thanks for replying. I also downloaded the below mentioned Oracle db access client using the below link and tried connecting to the oracle database.
But I receive the following mentioned error -"Details: "Oracle: ORA-12170: TNS:Connect timeout occurred".
Please help me in direct query. How do we query directly and any sample query with join statements.
Thanks,
Arun
@cslarun,
When connecting to Oracle database, choose “DirectQuery” mode and enter a high value in the "Command timeout in minutes (optional)" textbox.
In addition, you can review the join samples in this article: https://www.techonthenet.com/oracle/joins.php .
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |