Forum Discussion

Helper II

8 years ago

Solved

Azure Sql Data refresh for Import Model.

Hi,

I have created the reports from Azure Sql Database using Import method and published into Service.

now i am trying to do shedule refresh, but for that its asking gateway.

as my understanding when we use the Azure Sql, there is no need to configure Gateway.

please anyone can help me, how to do shedule refresh with out installing the Gateway.

Thanks,

Kapil

Tutorial Requests

v-huizhn-msft
8 years ago
Hi kapil512,

Yes, you don't need a gateway if the .pbix file only including Azure SQL Server data. In your .pbix if there is other data souce? For getting data from Azure SQL Server, please review this article.

Best Regards,
Angelia
bajee
8 years ago
Hi Kapil,

No need to configure the Gateway if your using AZURE Sql Server.

What you have to do is go power BI Service setting > select DataSource > Gateway Connection >click on Connect Directly.

That will create the direct connection with your AZURE SQL DB.

Regards,
Bajee.

3 Replies

v-huizhn-msft
Microsoft Employee
8 years ago
Hi kapil512,

Yes, you don't need a gateway if the .pbix file only including Azure SQL Server data. In your .pbix if there is other data souce? For getting data from Azure SQL Server, please review this article.

Best Regards,
Angelia
bajee
Kudo Kingpin
8 years ago
Hi Kapil,

No need to configure the Gateway if your using AZURE Sql Server.

What you have to do is go power BI Service setting > select DataSource > Gateway Connection >click on Connect Directly.

That will create the direct connection with your AZURE SQL DB.

Regards,
Bajee.
- kapil512
  Helper II
  8 years ago
  Thank you for your response..!
  
  This is working with out gateway connection.
  
  Thanks,
  Kapil

Related content