Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
7 years ago

Refreshing dataset in Power BI Service

Hi folks, I have Power BI Desktop report published to Power BI Service. The dataset refers to a database on a remote PC outside my organization.  I am looking for ways to set automatic refresh. I un...
Show and Tell
gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
7 years ago

The remote database is accessible from my PC. I extract data into my Power BI Desktop from it, then publish it to Power BI Service. I installed gateway on my PC, however when I try to connect my dataset from the Service by going to Dataset-Schedule Refresh, then Gateway Connection - Add to Gateway, I get "Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster."  It looks like Power BI Service is looking to connect to the remote PC directly, not to the Gateway in my PC :(

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi gvg ,

Please check if you can get data when connect to remote database in your machine. And check the authentication, server name, database name and etc. in gateway. You could reference the following document to collect logs from the on-premises data gateway app.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot

 

Best Regards,

Xue Ding

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