Report Builder: Connections using a Power BI Gateway are not supported

[bkwapisz]

Hello,

I am attempting to update a report that originally used a Power BI dataset to generate a paginated report. Now that the Power Query option has been added to the Report Builder, I attempted to connect the report directly to the mySQL database that the dataset was already pulling from, essentially eliminating the middle-man. The query editor allowed me to connect the the DB, select a gateway, manipulate the data just fine. The data previews worked as well. Once created, I added one point of data to the report just to test it and when I ran the report, I recieved the following error: "Connections using a Power BI Gateway are not supported." Am I missing something or is this not fully implemented yet?

[v-jtian-msft · Accepted solution]

Hi,@bkwapisz .I am glad to help you.
Based on your description, I think you are using a feature that is currently in Preview in Power BI Report Builder:

Unfortunately at the moment the feature is not complete enough and when you click on Get Data you are in fact using the Power Query Onine feature. It is a Power Query feature that is located in the cloud. The problem is that Power BI Report Builder, as a local application, if you want to use the Power Query Online engine in the cloud to perform ETL operations on the data source (extracting, transforming, and loading data), you have to use the gateway to connect to the data source that is also located in the local area (such as a local SQL Server database). The problem is that this feature is still in the development stage, and Power BI Report Builder does not yet support the use of gateways to get data sources (if you use Get data, i.e., get local data sources through the power Query Onine engine in the cloud, which is not supported in report builder for now). )
This is also documented in the error message. (I'll include a link to it in the test below).

You can try to get some cloud data sources using Get data to see if the same problem occurs.

If you want to get local data source to create reports, please select the third option Add Data Source.

Here is my test:
use "Get Data" Connect the datasource(use gateway :SQL Server)

Error while loading paginated report data: Unable to use getData to get local data source that requires a gateway connection.

This feature is also described in the official documentation:
URL:

Get data with Power Query available in Power BI Report Builder (Preview) | Microsoft Power BI Blog |...

Solution:
Please use the Add Data Source method to connect to the data source

URL:
Enter data directly into a paginated report in Report Builder - Power BI | Microsoft Learn
Please expect the report builder to also support the use of gateway connections in the near future, thank you for your understanding and support of the Power BI report builder.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ledi]

Do you know if this is now supported or if it will be supported in the January release?