Power BI Pro No Gateway

[syncwithconnex]

I am using Power BI pro online. My data is held inside of a SQL Server View. I am using direct query because the data in the view changes daily.

On my dashboard, I get this error:

There is no available gateway. Couldn't load the data for this visual

How do I resolve the error? Under gateways, I created one called default and I added my database connection string. I connected to multiple databases, but the one for the report connects successfully.

[edhans]

Please see this article @syncwithconnex - Troubleshooting gateways. You'll need to get log information and track down the specific issue, or post back here with more info on why it won't connect.

[syncwithconnex]

Hi,

My data is hosted on Windows Azure. Why do I need a gateway? When I use import, the query works fine. When I use direct query, it breaks. My problem is when I change the data in my view, my report fails to update. If I use import, how do I refresh the data? Maybe I just need to use import instead of direct query.

How do I pull the log? I just see this:

Couldn't load the data for this visual

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

Activity IDb240ea81-c9da-4fdc-ab0d-94504b2ed6e2
Request IDa59910b6-fecd-2e4b-f906-16db50cd629e
Correlation IDfad3684a-7041-90ea-cb28-b8f1fb878abd
TimeThu Dec 17 2020 13:19:44 GMT-0500 (Eastern Standard Time)
Service version13.0.14962.66
Client version2012.1.04159-train
Cluster URIhttps://wabi-us-north-central-g-primary-redirect.analysis.windows.net/

[edhans · Accepted solution]

It depends. What is "Windows Azure?" There are a lot of services in Azure, and most support a gateway, and some require it, but even those that do not will need a gateway depending on how you connected and set the report up. See this article. Furthermore, there are more specific Direct Query issues to be aware of where gateways are required here.