Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ikang
Frequent Visitor

Seeking Solutions for Full Feature Use of Power BI Desktop and Service on Virtual Machine

Our Power BI desktop files are stored on a virtual machine, which connects to a SQL server for creating dashboards and reports. For security reasons, internet access is restricted, requiring file transfer to another PC for uploading to the Power BI service. Due to the lack of internet connection, importing visuals is not possible. However, the Power BI service is linked to the SQL server via an on-premises data gateway. I'm exploring options to fully utilize Power BI Desktop or the Power BI service, perhaps through specific firewall settings. Any advice or guidance would be greatly appreciated.

1 ACCEPTED SOLUTION
v-jingzhan-msft
Community Support
Community Support

Hello @ikang 

 

Thank you for reaching out with your query regarding the use of Power BI Desktop and the Power BI service under restricted internet conditions. It's clear that you're looking to maximize the capabilities of Power BI while adhering to your organization's security policies. Let's address your concerns step by step.

 

For Power BI Desktop:

  1. Importing Visuals: As you've noticed, importing visuals from AppSource or other online sources requires an internet connection. To work around this, you should:

    • Initially, ensure you're connected to the internet to download and save any necessary custom visuals to your local machine or network.
    • Once downloaded, these custom visuals can be imported into your Power BI Desktop reports offline. For more details on working with custom visuals, please refer to AppSource Power BI visuals.
  2. Working Offline: Power BI Desktop can be used offline for most development work, including report creation and data modeling. However, features like AutoML, Q&A, and Quick Insights require cloud connectivity.

 

For Power BI Service Connectivity:

  1. On-premises Data Gateway: You've mentioned using an on-premises data gateway to connect the Power BI service to your SQL server, which is a great setup. To ensure smooth operation, make sure:

    • Your gateway is always updated to the latest version.
    • The gateway's machine has network access to both the SQL Server and the Power BI service through the internet. For more on data gateway configuration, visit On-premises data gateway.
  2. Firewall Settings: Adjusting firewall settings to allow specific traffic to the Power BI service can help you utilize it fully without compromising security. You'll need to:

  3. Private Links: For organizations with stringent security requirements, Azure Private Links provide a secure way to access Power BI service without exposing data to the public internet. For a detailed guide on setting this up, please refer to Azure Private Links for Power BI.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

1 REPLY 1
v-jingzhan-msft
Community Support
Community Support

Hello @ikang 

 

Thank you for reaching out with your query regarding the use of Power BI Desktop and the Power BI service under restricted internet conditions. It's clear that you're looking to maximize the capabilities of Power BI while adhering to your organization's security policies. Let's address your concerns step by step.

 

For Power BI Desktop:

  1. Importing Visuals: As you've noticed, importing visuals from AppSource or other online sources requires an internet connection. To work around this, you should:

    • Initially, ensure you're connected to the internet to download and save any necessary custom visuals to your local machine or network.
    • Once downloaded, these custom visuals can be imported into your Power BI Desktop reports offline. For more details on working with custom visuals, please refer to AppSource Power BI visuals.
  2. Working Offline: Power BI Desktop can be used offline for most development work, including report creation and data modeling. However, features like AutoML, Q&A, and Quick Insights require cloud connectivity.

 

For Power BI Service Connectivity:

  1. On-premises Data Gateway: You've mentioned using an on-premises data gateway to connect the Power BI service to your SQL server, which is a great setup. To ensure smooth operation, make sure:

    • Your gateway is always updated to the latest version.
    • The gateway's machine has network access to both the SQL Server and the Power BI service through the internet. For more on data gateway configuration, visit On-premises data gateway.
  2. Firewall Settings: Adjusting firewall settings to allow specific traffic to the Power BI service can help you utilize it fully without compromising security. You'll need to:

  3. Private Links: For organizations with stringent security requirements, Azure Private Links provide a secure way to access Power BI service without exposing data to the public internet. For a detailed guide on setting this up, please refer to Azure Private Links for Power BI.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors