Forum Discussion

r4m4nxd's avatar
r4m4nxd
Regular Visitor
2 years ago
Solved

Direct Query report published but disconnected

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 Se...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, r4m4nxd 

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.

 

 

Then Map to your connection, select apply.

 

If your refresh is normal, then the gateway connection is successful

 

You can learn more about the following link:

Add or remove a gateway data source - Power BI | Microsoft Learn

 

Create and share cloud data sources in the Power BI service - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • r4m4nxd's avatar
    r4m4nxd
    Regular Visitor
    2 years ago

    Thank you so much.

    Although I already had a connection made for the same database in that gateway, I recreated another connection with same credentials and database name. It finally showed up in the drop down, and now the refreshes are running smoothly.

    Thank you very much for detailed guidleines.