Report Builder Connection to Datasource with Gateway Error

[asch2]

Hi all,

We have successfully connect Report Builder reports to our Databricks' tables in one of environments.  However, we are migrating to more secure environments that will require a connection.  The gateway we have set up works for our other .pbi reports.  Does anyone know why I may be getting the error below when using the gateway in Report Builder to directly connect?

I am happy to provide more info is needed.  Thank you!

[Anonymous · Accepted solution]

Hi, @asch2 

Direct connections using Power BI Gateway in Report Builder are not supported. This is a known limitation.
With a direct cloud connection, make sure you're establishing a direct cloud connection to the data source and not using a gateway.

Or export the data from a connected source to a supported format, such as Excel, and then import the data in Report Builder.

You can refer to the documentation for the gateway and Report builder:

Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Subject: Assistance Required: Report Builder Connection to Datasource with Gateway Error.

Dear Support Team,

I hope this message finds you well.

I am writing to seek assistance regarding an issue I am encountering with Report Builder. Specifically, I am facing a connection error when attempting to connect to a datasource through a gateway. If you can help me to resolve in this regard that will be highly appreciated.

Best Regards,

Moazzem Hossain