Forum Discussion

ltkort's avatar
ltkort
Frequent Visitor
10 years ago

Refreshing data never goes right, help?!

Hi,   I have a data source (ODBC) running on one computer. It's always on and has a wired internet connection. It's connected to a database from our website. The serverconnection can only be access...
ltkort's avatar
ltkort
Frequent Visitor
9 years ago

Anonymous Okay, I figured it out. I now have a on premise data gateway, I added the datasources and they are connected.. But when I am in Schedule refresh I cannot click on manage gateways... I do not know whats wrong

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ltkort,

When we add data source under gateway, we should input connection string like"dsn=sourcename". For more details, you can review the following screenshots.

1. Check your odbc source name(testodbc1 in my scenario) in Power BI Desktop.


2. Add data source under gateway by entering connection string , account and password .


3. Schedule refresh for dataset in Service.



Thanks,
Lydia Zhang