Forum Discussion

raji_chandra's avatar
raji_chandra
Regular Visitor
5 years ago

Power BI Service Data Refresh issues

Hello,   I recently started facing data refresh failure in Power BI service when I am not logged into my computer. The data source is SQL Server. I am able to connect with the SQL server in ADF and...
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

Hi Raji! can you tell us a bit more? is the SQL Server an onpremise DB engine? do you have a gateway installed? Which one (personal/standard)?

That might help us to help you

Regards,

  • raji_chandra's avatar
    raji_chandra
    Regular Visitor
    5 years ago

    Hello,

     

    Thanks for the reply! The SQL DB is in the cloud, Azure SQL Server. The gateway is installed in the computer and it is standard.

     

    Regards,

     

    • ibarrau's avatar
      ibarrau
      Super User
      5 years ago

      Oh. You shouldn't be using gateway if it is a Azure SQL Database. You can directly connect the Power Bi Service with Azure SQL Database just editing the credentials. Unless you have another on premise source you can avoid gateway. 
      The gateway need the PC or Machine working turned on. That should be all because once you logged in it will run a service in windows.

      Even though it looks like there is a timeout. That can be because of a bad login or the response of the server is slow and the timeout runs. Try expanding the timeout for command and connection in Power Query code. This doc shows the parameters you can use:

      https://docs.microsoft.com/en-us/powerquery-m/sql-database

       

      I would add more time there and if the DB is the only source, try connecting that source directly without gateway and just editing credentials.

       

      I hope that helps,