Forum Discussion

LoganDuan1987's avatar
LoganDuan1987
New Member
10 months ago
Solved

How to Use an On-premises or VNet data gateway?

Hello!   I create a Power BI dashboard with the SAP HANA Database. The gateway is personal gateway running on my personal computer (CN01-GX5YDY3). When my computer is offline such as weekend, the d...
Need Help
  • Shubham_rai955's avatar
    Shubham_rai955
    10 months ago

    Yes, LoganDuan1987  you are correct: when you use an On-premises or VNet data gateway (not the personal gateway), your Power BI dashboard can refresh even if your personal computer is off.

    Steps to Use On-premises or VNet Gateway

    • Install the On-premises data gateway on a dedicated server or always-on computer (not your personal PC).
    • Add your SAP HANA data source in the Gateway settings in Power BI Service.
    • In Power BI Service, go to your dataset settings > Gateway and cloud connections.
    • Select the On-premises/VNet Gateway (not personal). If you cannot select it:
    • Make sure your dataset matches the connection details registered in the gateway.
    • Ensure you have permission to use the gateway (ask your admin).
    • Update your dataset credentials to use the gateway.

    This will let your dashboard refresh automatically, even when your personal computer is off

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi LoganDuan1987 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

LoganDuan1987's avatar
LoganDuan1987
New Member
9 months ago

Hi Anonymous 

Thank you for reaching out.

This issue has been resolved according to the answers everyone kindly provided.

Please close this incident on behalf of me. 

Many thanks.