Forum Discussion

Stharwani's avatar
Stharwani
Advocate II
9 years ago
Solved

Connecting to On Premise SQL Servers

I am trying to connect Power BI to multiple on premise SQL Server instances. What is the advantage of using a gateway? 
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Stharwani,

    The Power BI gateway acts as a bridge, providing quick and secure data transfer between on-premises data and Power BI.

    In your scenario, after you connect to SQL Server databases from Power BI Desktop, create reports and publish the Power BI Desktop file to Power BI Service, you can use gateway to refresh your dataset in Power BI Service, this way, each time you make changes in SQL Server data source, the changes will be reflected in dataset and reports in Power BI Service based on refresh schedule, for more details, please review the following link.

    https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Stharwani,

The Power BI gateway acts as a bridge, providing quick and secure data transfer between on-premises data and Power BI.

In your scenario, after you connect to SQL Server databases from Power BI Desktop, create reports and publish the Power BI Desktop file to Power BI Service, you can use gateway to refresh your dataset in Power BI Service, this way, each time you make changes in SQL Server data source, the changes will be reflected in dataset and reports in Power BI Service based on refresh schedule, for more details, please review the following link.

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/

Thanks,
Lydia Zhang