How to connect to OLE DB or ODBC in Power BI report builder

[Anonymous]

Hi All,

In our project we are migrating reports from SSRS to Power BI through Power BI report builder by importing the .rdl files.

There are 2 reports in SSRS coming from cube database, when these reports .rdl file is imported into report builder it is not returning data.

Can you suggest me how to connect to OLE DB or ODC concetion in report builder.

Thanks in Advance,

Neelofer.

[Anonymous · Accepted solution]

HI @Anonymous,

As the document mention, the latest version of the power bi report builder already supports the odbc data source.

Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft Docs
Please check the odbc driver configuration and versions to confirm if they match with the current report builder.

Create data connection strings - Report Builder & SSRS - SQL Server Reporting Services (SSRS) | Microsoft Docs

In addition, if migrated report connections do not work, have you tried to rebuild the report with odbc connections on the power bi report builder side?

Regards,

Xiaoxin Sheng

[Anonymous]

We are trying to build a report in power Bi report builder with OLE BD data source wanted to know if this supports.