Forum Discussion

Prabukarana's avatar
Prabukarana
Regular Visitor
9 years ago

auto refresh with ODBC datasaource

Hi...   How to connect auto Refresh with odbc database. I try to read tutor before but still not solved.   I use Power BI Desktop, and then i publish to Power BI web. All of running well.   and...
Tutorial Requests
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Prabukarana,

I try to click button refresh in Power bi web, but no action. If i do that in Power BI Desktop running well.

The refresh button is used to refresh tiles on the report.

 

In order to refresh your dataset on the service, you can either select the ellipse (...) for the dataset, and click "REFRESH NOW" to manually refresh the dataset immediately, or you can follow steps from this article to configure a schedule refresh for it.:smileyhappy:

 

 

Regards

Prabukarana's avatar
Prabukarana
Regular Visitor
9 years ago

Hi v-ljerr-msft thank you for reply.

 

I Know now my problem is in dataset. I already install On-Premises data Gateway.  Succes instalation.

But when i add datasource. It failed configuration. 

 

 

Configuration sama with my odbc in local computer. Still get Error.

 

 

 

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Prabukarana,

     

    What's the connection string you're using for the configuration? Here is a similar thread about how to add ODBC data source under gateway, could you go to check if it helps in your scenario? :smileyhappy:

     

    Regards