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.