How to connect Power BI data to Firewall server

김재민 1 Reputation point
2020-09-11T07:08:49.313+00:00

Hello.

Data visualization is in progress through "power bi".

The problem I have is.

Because of a firewall on the server using the Naver Cloud Platform

Importing data from "power bi" is not possible.

I need to disable the firewall for "power bi" via acg config

How are IP and port of power bi configured?

Since this question was written through a translator, the sentence could be weird.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,798 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. KalyanChanumolu-MSFT 8,316 Reputation points
    2020-09-11T07:15:01.057+00:00

    @김재민

    It is not very clear from your question if you are using Azure SQL Database or SQL Server on a VM.

    If you are using Azure SQL Database, please Allow access to azure services on the Azure SQL Server firewall

    23970-image.png

    PowerBI is not supported on Microsoft Q&A.
    If you have further questions, you can post it on Microsoft Power BI Community Forums for better visibility.

    0 comments
  2. Olaf Helper 40,741 Reputation points
    2020-09-11T07:44:46.1+00:00

    See Add Power BI URLs to your allow list for a list of URL and used ports.

    0 comments
  3. Joyzhao-MSFT 15,566 Reputation points
    2020-09-11T08:31:13.717+00:00

    Hi @김재민 ,

    The Power BI Data Gateway, as the name suggests, is a kind of gateway that acts as a connecting platform between the Power BI Cloud service and the on-premise datasets that are not on the cloud. For example, if you have set up your data sources on your local system or on a customer’s data center which is behind a firewall, you will need to install the Power BI Data Gateway for the Power BI Service to be able to connect to those data sources and fetch the data.

    The Power BI Data Gateway is not only limited for use by Power BI, but it can also be used by the other Azure cloud services like the Azure Analysis Services, Power Apps, Azure Logic Apps, and Power Automate. All these cloud services can use the same data gateway without any other specifications required.

    Please refer to: Add Power BI URL to your allow list 、 How to configure Power BI Enterprise Gateway Proxy configuration?and How to know IPs related to Powerbi online for Opening Firewall Port. Hope it helps.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments