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

[SvenTexas]

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:webservices or gateways that will be needed to get the report to reference a live datasource and not just the data that was uploaded with it when it was published please?

We have a server in the DMZ (de-militarised zone) that I can populate with data from internal databases - so it's not the data that is the problem - more about what I would need for a link between the published version and our DMZ server.

Thankyou.

[v-qiuyu-msft]

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]

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

Thankyou for your help.

[v-qiuyu-msft · Accepted solution]

Hi @SvenTexas,

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

Best Regards,
Qiuyun Yu

[ankitpatira]

@SvenTexas The only way currently is to use pbix file within power bi desktop and via query editor change the source and save. Then republish to power bi service which will replace your published dataset with the new one. Ofcourse you will then need to setup gateway and depending on the mechanism you're using to data source such as directquery.

[SvenTexas]

Thankyou @ankitpatira, what is involved in setting up the gateway? I guess our network guys would set that up - would there be anything that I would have to give them to help?

Thanks.