How do I connect to Oracle in Microsoft Report Builder (Windows 11)

Question

We are testing Windows 11. No matter what drivers we install, Microsoft Report Builder will not enable the "Build" button on the Data Source Properties page. This works on Windows 10. We tried installing the ODAC components that worked on Windows 10. Then, we added everything except the kitchen sink. We have started clean multiple times, to avoid conflicting installations.

The Data Source connection works for MS SQL Server and other connection types. It works for Oracle ESSBASE. Just not the Oracle Database.

Visual Studio connects to Oracle. Power BI Desktop connects to Oracle. So, we have drivers that allow some Microsoft development tools to work, just not Report Builder.

Ideas?

Answer 1

Hi,

Thank you for posting your query.

Kindly follow the steps provided below to resolve your issue.

To use data from an Oracle database in your report, you must have a dataset that's based on a report data source of type Oracle. This built-in data source type uses the Oracle Data Provider directly and requires an Oracle client software component. This article explains how to download and install drivers for Reporting Services, Power BI Report Server, Report Builder, and Power BI Desktop.

Go to this link for your reference and other troubleshooting procedures https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs

Do not hesitate to message us if you need further assistance.

If the answer is helpful kindly click "Accept as Answer" and up vote it.