Forum Discussion
Microsoft Employeehow to set a gateway
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!!
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
6 Replies
- BhaveshPatel
Super User
Please check this link for connectivity to Azure SQL Database.
https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-and-power-bi/
v-micsh-msftHi 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
Resolver I
I wrote this blog specifically to address this.
http://www.businessintelligencebuilder.com/#!Power-BI-Gateways/c21xo/57858f6a0cf25aa82d55635c
MP_123hi, 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!
