Direct Query report published but disconnected

Question

Hi Everyone, I have a PBI report which I am using to show real time data, every minute, using page refresh on direct query.
However, it is only working on the desktop version, not on the Power BI Service.

Few things I did was-
1. Make a direct query connection for the table in report.
2. turned on page refresh, which worked on the Desktop version.

3. When I published the report on Power Bi Service, it showed report disconnected.

4. I have tried multiple solutions found online, none of them are working for me.
5. I have re-configured the gateway as well. But it still keeps showing There is no gateway to access the data source 'database name'.

This only happens if I have a direct query connection, as soon as I change that table to import connection, it is working all fine, automatically makes the database connection thru gateway.

I cannot find any solution for it to work further.

has anyone dealt with the same issue before?
It is out of my thinking scope now. Any help would be appreciated.

anonymous · Accepted Answer

Hi,&nbsp;r4m4nxd&nbsp;
First, you need to check if you have a gateway

Find your semantic model and set it up. Once you're in the settings, select Gateway and Cloud connection

Select Add to gateway

Create a new connection.
&nbsp;

&nbsp;
Then Map to your connection, select apply.

&nbsp;
If your refresh is normal, then the gateway connection is successful

&nbsp;
You can learn more about the following link:
Add or remove a gateway data source - Power BI | Microsoft Learn
&nbsp;
Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn
&nbsp;
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.