"Failed to use the selected gateway." when adding Streaming DirectQuery dataset to datamodel

[nateharwood]

Hi, I really hope you can help.

I currently use a personal gateway to connect to a MySql database in service, which works absolutely fine. However, when I add a DirectQuery connection to a PowerBI streaming dataset to the data model, I'm suddenly no longer able to use the gateway and receive the following error:

Activity ID: f0f16fd2-6671-49ab-81ae-986c7c3005a0
Request ID: 1c4dbb2e-f1aa-3a23-2955-4241219a16cf
Correlation ID: 23d606af-942b-9bf1-131a-dab43e413da3
Status code: 400
Time: Sat Mar 25 2023 15:27:43 GMT+0000 (Greenwich Mean Time)
Service version: 13.0.20342.55
Client version: 2303.3.12949-train
Cluster URI: https://wabi-uk-south-c-primary-redirect.analysis.windows.net/

Note that on desktop it works absolutely fine, although I'm importing directly from the MySQL database and therefore not having to use the gateway. Please see below screenshot from my data model for reference.

One thought crossed my mind - does the gateway need to be amended to enterprise? I'd be surprised by this though, given the streaming dataset doesn't use the gateway? Please let me know if you need any more information.

Many thanks,

[nateharwood]

Thanks @TomMartens - switched to enterprise gateway and works perfectly. Appreciate your help!

[TomMartens · Accepted solution]

Hey @nateharwood ,

a personal gateway does not support direct query connections: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

As you added a second data source to your Power BI desktop file that is not supported by the gateway. The error occurs.

You have to use a gateway in standard mode (fka Enterprise gateway).

Regards,

Tom

P.S.: It's not necessary to add a screenshot from the error message as this does not reveal anything to us.