Forum Discussion
Helper IIGateway needed for cloud-only connections?
Helper IIThe source is in Serverless Synapse SQL, a cloud service.
Under https://app.powerbi.com/groups/me/gateways
I have a connection set up that is "cloud" to the server. When I try to publish a report the dataset requires me to map the connection:
All is good, but then why does it want me to use a gateway? The error says
"This model requires a gateway. Choose a gateway..."
Activity-ID a74a5012-135f-4fbe-b994-cdb7199fecde
There is only one source to the data which is the cloud connection, so it prompts me to use gateway, even though I should not need to use it.
- aj1973
Community Champion
- agneum
Are you saying that it cannot be connected to like a regular SQL Server, you have to use this .pbids file?
The .pbids file is esentially just a connection to the Serverless SQL Pool, it's no different. I can open a new Power BI desktop file, and connect to SQL server as normal. The only difference is that there is now a "linked servce" relating to the Workspace in Synapse. Is the linking at all relevant to being able to refresh the reports, we do not intend to use Synapse Studio at all. I assume linking is just if you want to work in Synapse Studio, I don't see it having any impact on the issue with refreshing the datasets.
Anways, this doesn't solve the issue of "Refresh failed because this semantic model requires a gateway" error, when I only have 1 single cloud source.- aj1973
In the Desktop you can't use the regular SQL server. You have to use Azure connector
- aj1973
You might also need to edit credentials, did you do that?
https://www.youtube.com/watch?v=rx6JpIpq9QY
