Forum Discussion

rchristie's avatar
rchristie
Frequent Visitor
5 years ago

Gateway not refreshing

Hi,   We use personal on premise gateways to enable refreshing of reports using data in an Micorsoft SQL Server Database.   Reports updates have stopped working for at least the last week. Below ...
Need Help
aj1973's avatar
aj1973
Community Champion
5 years ago

Hi rchristie 

Are you able to connect your Power bi desktop to the data source?

 

rchristie's avatar
rchristie
Frequent Visitor
5 years ago

Hi,

 

I'm able to connect power bi desktop to data source and can refresh manually in power bi desktop.

 

I created a test report with a small query and that won't work either so it's not a time out issue either.

 

Regards,

Ross

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    Hi, rchristie 

    Is the report created with Import connection mode to SQL Server and refresh data with personal gateway(If the connection mode is DirectQuery, only enterprise gateway can be used to refresh)? If so, you can try the following steps.

    1 Make sure the gateway is the lasted version and the status of the gateway is online (It can be seen in Gateway connection of the dataset Setting)

    2 Check the status of the SQL Server whether it is running

    3 Edit credentials in dataset Setting pane

    4 Check whether the firewall prevents the connection to data source   

     

    Best Regards,

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • rchristie's avatar
      rchristie
      Frequent Visitor
      5 years ago

      Hi Caiyun Zheng,

       

      The gateway is running and on the February 2021 release which I believe ot be latest.

       

      The SQL server is running.

       

      The credentials are the same. I can refresh from the Power Bi Desktop application.

       

      How do I go about figuring out if this is a firewall issue? The gateway has worked in the past but it may be possible that a change to firewall settings was carried out by our IT department.

       

      Regards,

      Ross

       

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        rchristie 

        Very easy to verify if it is the Firewall the issue. Ask your IT department to turn off the firewall for a while until you retry refreshing the Gateway.