PowerBI gateway required for report with Azure SQL connection

[AdamMarczak]

Hello,

I've created report that downloads multiple datasets via SQL queries from single database hosted in Azure (PaaS). All are embedded mode.  I also have few datasets from manual input (via Enter Data feature).

I published this report but PowerBI.com requires me to install gateway. Why is that? All my data is either entered manually or from Azure SQL. 

I also created very small sample report (new file) where I added one exacly same query (copied via advanced editor) and one enter data set and after publish it doesn't require gateway. Is there something wrong with my file?

Note: I previously had some CSV loading sources in my query window but I removed them all and now I only see one azure sql on data source list.

Kind regards,
Adam.

[AdamMarczak · Accepted solution]

After lots of empirical testing I found out that I was using database.secure.windows.net instead of database.windows.net domain for server DNS address. After changing all URLs I can now schedule refresh normally.