Сonnection to Power BI Report Server RRS feed

  • Question

  • Hello. We are trying to connect Vertica DBMS to Power BI Report Server. We read on the PBI website that Vertica can be connected via Gateway. We tried to make a connection according to the instructions and videos on YouTube, but we do not see the Gateway settings button. We have an account with server admin rights. What can we try to do?
    Wednesday, August 10, 2022 3:37 AM

All replies

  • In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network. Follow these steps to add your on-premises SQL Server database as a data source to a gateway and then connect your dataset to this data source.

    Sign in to Power BI. In the upper-right corner, select the settings gear icon and then select Settings.

    Power BI settings

    On the Datasets tab, select the dataset Adventure Works Products, so you can connect to your on-premises SQL Server database through a data gateway.

    Expand Gateway connection and verify that at least one gateway is listed. If you don't have a gateway, see the Prerequisites section earlier in this tutorial for a link to the product documentation for installing and configuring a gateway.

    Under Actions, expand the toggle button to view the data sources and select the Add to gateway link.

    If you're not a gateway administrator and don't want to install a gateway yourself, contact a gateway administrator in your organization. They can create the required data source definition to connect your dataset to your SQL Server database.

    On the Gateways management page, on the Data Source Settings tab, enter and verify the following information, and select Add.

    On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.


    Ross Smith

    Wednesday, August 10, 2022 9:19 AM
  • Here are four quick steps to get you started.
    1. Step 1: Install Power BI Desktop for Power BI Report Server. 
    2. Step 2: Select a data source. 
    3. Step 3: Design your report.
    4. Step 4: Save your report to the report server.

    Hope you get the answer !!

    Glad to helping you.

    Wednesday, August 17, 2022 9:59 AM