Home » Power BI » On-Premises data gateway Personal Mode

On-Premises data gateway Personal Mode

End to End Setup On- Premises Gateway Personal Mode

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 (personal mode)

Only you can use this, and you can use it only for scheduling refresh in Power BI. The Live Connection connectivity mode, PowerApps, Logic Apps, Microsoft Flow are not supported.

Refer – Standard mode gateway




Topics to be cover in video:-

1. Understand Personal Mode Gateway.

2. Works with Excel & SQL Datasource.

3. Publish Report to power bi Cloud.

4. Download Gateway.

5. Install Gateway Step by Step.

6. Update Datasource credentials on Cloud.

7. Understand manual & schedule refresh & set the time for dataset 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.

Leave a Reply