Publish ok, preview not ok

[FernandoFaria]

Good night.

I'm new to the world of Power BI and I already have a question that should be basic: I created a report, using Power BI Desktop, using a connection to SQL Server in the cloud, not Azure (AWS). While I'm on the Desktop everything works. I decided to publish in My Workspace so that my team had daily access to updated data. Publishing finishes fine BUT when trying to open the report via the generated link (or even via Worspace) you get error message "There is no gateway to access the data source...". I don't understand: the data comes from the cloud (web) and the report is published in the cloud (web). I know the gateway is for on-premise installations, so what do I need it for?

Tks in advance

[FernandoFaria]

@Greg_Deckler , thank you. You clarified what I need to do.

I'm going to download the gateway and, next, configure it.

If I have other question, I'll open a new post.

For now, my question was "solved".

Tks again.

[Greg_Deckler · Accepted solution]

@FernandoFaria It sounds like you used a DirectQuery connection and not Import, is that correct? If that is correct, you need a gateway regardless of whether the source is a SQL Server on-premises or in the cloud. For import models you don't have to do this in most cases when the data is accessible on the Internet.