Forum Discussion

srkase's avatar
srkase
Icon for Helper IV rankHelper IV
5 years ago

LIVE DATA CONNECTION ISSUE

Hi,   In my laptop I have created one Dashboard report , with data from SQL server using direct query option.  Have completed the dashboard and uploaded to app.powerbi.com to share with my organisa...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey srkase ,

 

where did you install the gateway? I guess on your notebook, right?

In DirectQuery mode whenever someone is opening the report or clicking something in the report, the Power BI Service will contact the Gateway and the Gateway will query the datasource and send the values to the Service. That's the idea behind DirectQuery as the name says already.

 

For that reason the gateway should be installed on a server or computer that is always available in your company. Never install a productive gateway on a personal notebook. Not only when you finished working, the report will not be available, also when you're sick, you're on holiday, you reboot and so on.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis