Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Supporters!
If I want to use ODBC connector to connect to Oracle database in Report builder for the FIRST TIME, what do I need to do and from where do I need to install the ODBC connector/ driver?
Solved! Go to Solution.
Hi @AsNa_92 ,
Power BI Report Builder requires the 64-bit version of the ODBC driver. Ensure you download the 64-bit version to avoid compatibility issues.
It's generally a good practice to use the latest version of the ODBC driver to benefit from the latest features and security updates.Typically, you only need to download and install the ODBC driver itself. The Basic Package is not necessary unless specified by the driver documentation.
If you are using a specific database like Oracle, ensure you download the corresponding ODBC driver version that matches your database version and operating system.
Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AsNa_92 - To connect to an Oracle database using an ODBC connector in Power BI Report Builder
Download and Install the Oracle ODBC Driver:
Configure the ODBC Driver:
Set Up an ODBC Data Source (DSN):
Connect to Oracle from Power BI Report Builder:
Hope the above steps helps to configure.
Proud to be a Super User! | |
In the URL to download the ODBC driver, there are so many version. Can I choose any version or it depends on my report builder version?
Also, do I have to download and install the Basic Package as well or only the ODBC driver?
Hi @AsNa_92 ,
Power BI Report Builder requires the 64-bit version of the ODBC driver. Ensure you download the 64-bit version to avoid compatibility issues.
It's generally a good practice to use the latest version of the ODBC driver to benefit from the latest features and security updates.Typically, you only need to download and install the ODBC driver itself. The Basic Package is not necessary unless specified by the driver documentation.
If you are using a specific database like Oracle, ensure you download the corresponding ODBC driver version that matches your database version and operating system.
Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |