Azure Sql Data refresh for Import Model.

[kapil512]

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

[v-huizhn-msft · Accepted solution]

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 · Accepted solution]

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]

Thank you for your response..!

This is working with out gateway connection.

Thanks,

Kapil

[v-huizhn-msft · Accepted solution]

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