how to set a gateway

[MP_123]

hi all,

i want to set a gateway to my reports and actually i don't really understand from the power bi site how to do it.

now my reports are connected with the default gateway - which is my machine

i want to set it to a gateway since my computer doesn't online all the time, etc..

can someone explain me how to do it? where to i download the enterperise gateway?

my data source is Azure sql datawarhouse

thanks!!

[v-micsh-msft · Accepted solution]

Hi MP_123,

Gateway is used to connect the Data source that hosted locally.

For the Databases in the cloud, a gateway is not required. The only thing that should be done here is to configure the connection, specify the database address and the credentials, check:

Exploring Azure SQL Data Warehouse with Power BI

And:

Use Power BI with SQL Data Warehouse

If any further help needed, please feel free to post back.

Regards

[cosborn1231]

I wrote this blog specifically to address this.

http://www.businessintelligencebuilder.com/#!Power-BI-Gateways/c21xo/57858f6a0cf25aa82d55635c

[MP_123]

@v-micsh-msft

hi, thanks!

i understand that gateway is not required, but you mean to directQuery only right? 

how it should be implemented with import data?

i'm using personal gateway and it works fine for now, but if my computer is off, then the refresh won't happen, right?

thanks!

[Seth_C_Bauer · Accepted solution]

@MP_123 You don't need a gateway when importing. You would just need to set up a schedule for refresh. Check out this page for all the refresh scenerios.

[MP_123]

thanks!

@Seth_C_Bauer

[v-micsh-msft · Accepted solution]

Hi MP_123,

Gateway is used to connect the Data source that hosted locally.

For the Databases in the cloud, a gateway is not required. The only thing that should be done here is to configure the connection, specify the database address and the credentials, check:

Exploring Azure SQL Data Warehouse with Power BI

And:

Use Power BI with SQL Data Warehouse

If any further help needed, please feel free to post back.

Regards

[BhaveshPatel]

Please check this link for connectivity to Azure SQL Database.

https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-and-power-bi/