Changing connection in Power BI service after publishing a report

[Shapiran]

Hi,

Is there a way to change a data source after publishing the report to Power Bi service?

For example, we develop a report in SQL server test environment using Power BI desktop.

Once publish the report we would like to connect to production.

However, we can select only a gateway connection with test connection details.

Thanks,

Nir

[DevMunshi]

configure the DSN as a parameter in DAX and re-point on the app. 

[v-yuta-msft]

@Shapiran ,

If the datasource has been changed(e.g.: server name, location, credentials or others), you can configure the data source settings in manage gateway section. For more details, please refer to doc below:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-manage

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shapiran]

Hi,

Can you please provide details?

I didn't find any details how to edit a data source in the document attached.

I can only change the data source name and authentication details only.

For Example, SQL server data source can change only the following fields:

data source name

Authentication method

Username

Password

Field that can't be changed (greyed out):

Data source type

Server

Database

The fields that I need to change are server and database.

Thanks,

Nir

[v-yuta-msft · Accepted solution]

@Shapiran ,

If you need to change the database name and table, I'm afraid you should do this in power bi desktop and republish the report. Or you can create a dataflow entity so that you can edit these data source properties online.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

Hi @Shapiran ,

You can do it using parameters.

Once it published you can change the values online.

https://powerbi.microsoft.com/pt-br/blog/deep-dive-into-query-parameters-and-power-bi-templates/

https://workingondata.wordpress.com/2018/03/26/modify-parameters-for-datasets-published-to-powerbi-c...

Ricardo

[Shapiran]

Hi Ricardo,

Thanks very much for your answer.

This is very interesting approach. 

I was able to create and edit a parameter to change to source from Power BI desktop.

However, I didn't see any option the select the parameter in Power BI service (after publishing).

Let me try to elaborate more about my problem:

I'm developing a report in Power BI desktop connecting to development environment.

Due to security restrictions I can't access to the production environment.

The gateway is installed on a server that can access the production environment.

Is there any way to select a different data source (from tha gateway) than the one that was published via Power BI desktop?

Thanks,

Nir