Forum Discussion

wkolcz's avatar
wkolcz
Frequent Visitor
5 years ago
Solved

Scheduled refresh ( from remote database ) are greyed out

I published my first report online (I'm still pretty new) and I created a report that is connected to a mysql database and published it to our pro cloud account online. I can view it online and it wo...
Need Help
  • collinq's avatar
    collinq
    5 years ago

    Hi wkolcz ,

     

    To get the Refresh to work online you will need a gateway to be setup and used by this report online.  First, set up the gateway with the appropriate connections to your local data source (and test).  Then, set that as you Gateway Connection in the dataset sources online (and confirm that the status is green).  Then, schedule refresh will be available to you.

wkolcz's avatar
wkolcz
Frequent Visitor
5 years ago

My database is behind a server firewall with the port open for the database. I have created a user for the report that has access. It works in my desktop version without a gateway and does work when I installed a gateway on my desktop but I am not sure why it has a problem getting an update when it has access.

 

When I posted it to the web originally, was the data from the database downloaded locally to the desktop version prior to posting it and thats why it works online?

collinq's avatar
collinq
Icon for Super User rankSuper User
5 years ago

Hi wkolcz ,

 

To get the Refresh to work online you will need a gateway to be setup and used by this report online.  First, set up the gateway with the appropriate connections to your local data source (and test).  Then, set that as you Gateway Connection in the dataset sources online (and confirm that the status is green).  Then, schedule refresh will be available to you.

  • wkolcz's avatar
    wkolcz
    Frequent Visitor
    5 years ago

    Thank you!