What is Gateway?
Gateway is an application and it provides the connection between Power BI cloud services and the data source located on-premises.
Using gateway you can schedule refresh the datasets on cloud. You can installed this application on any servers in the local domain.
Gateway is required- If the data source is located on-premises, then you need a gateway. Means, any local files, whether they are on a virtual machine or your local desktop, will require a data gateway.
For example- If you are fetching data from SQL Server database located on your local domain server, then you need a gateway.
Not required– for online or cloud-based data sources. For example- if you are getting data from CRM Online, Azure SQL DB, Azure Blob Storage etc., you don’t need a gateway.
On-premises data gateway(standard)
This gateway can be used by multiple users that have access to the server onto which you install the gateway. It can be used for both scheduling refresh and live queries in Power BI.
You can also use it for Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows.
Refer – Personal Mode Gateway
Topics to be cover video:-
1. Understand Standard Mode Gateway.
2. Connect with SQL Datasource with Direct Query & Publish report to Power BI cloud.
3. Download & Install Gateway step by step.
4. Add Datasource for Gateway cluster on Power BI cloud.
5. Understand scheduled cache refresh.
Refer – personal mode Vs standard Mode
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.