Forum Discussion
Helper IIGateway needed for cloud-only connections?
Helper IIAre 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.
Community ChampionIn the Desktop you can't use the regular SQL server. You have to use Azure connector
- agneum
I've tried this, the .pbids export string seems to be the same regarldess if I choose Azure SQL database, Azure Synapse Analytics SQL or regular SQL Server connection. I published a report using Azure SQL as the source. The dataset owner can refresh the dataset, everyone else gets "you need a gateway installed" error when attempting to refresh. It's very strange because it only happens with Synapse Serverless SQL, it does not happen for example with Azure SQL, even though when check the connections they are both Cloud, both authenticate with "basic" , have all the same settings and shared with the same people. Refreshing any report built on the Azure SQL works fine, but not the Synapse one.
The only way it works if I do refresh via API