Forum Discussion

SvenTexas's avatar
SvenTexas
Frequent Visitor
10 years ago
Solved

Published Power BI report using web service to get data from DMZ

Hi.  I have a published a dashboard on PowerBI.com using a static datasource, but now need to link the dashboard to a live SQL database curently on site.  Can anyone detail the steps to re:webservice...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi SvenTexas,

     

    It seems the issue is solved. Would you please mark the helpful reply as an answer?

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi SvenTexas,

 

According to your description, you already published a report to the Power BI service. And you want to change the data source of this report from a static data source to a live SQL database, right?

 

As ankitpatira mentioned, we need to modify the data source of the report in Power BI Desktop, then republish it to Power BI service.

 

As you are connecting to the SQL Server database which requires gateway to build connection, before publish the report, you can configure the SQL Server data source under on-premises data gateway firstly. Once publish is successful, the report is using this gateway automatically.

 

To configure the data source under on-premises data gateway, you can go to Gateways page, create a SQL Server data source with the same server and database name used in the report.

 

 

Reference:
Manage your data source - SQL Server

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

SvenTexas's avatar
SvenTexas
Frequent Visitor
10 years ago

Thankyou v-qiuyu-msft - you are correct - that is exactly what I wanted to read.

 

Thankyou for your help.

 

 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    10 years ago

    Hi SvenTexas,

     

    It seems the issue is solved. Would you please mark the helpful reply as an answer?

     

    Best Regards,
    Qiuyun Yu