Change datasource

[bernardoflynn]

Our data is in Postgres. We created a host of reports using the Postgres connector in Personal Gateway but need fresh data so need to use Enterprise Gateway.

Enterprise gateway does not support Postgres.

So one option is to copy all our data into a read only MySql db and change the reports to work off that.

How do I change the datasource in a report/dashboard?

[v-qiuyu-msft]

Hi @bernardoflynn,

In your scenario, you can import the data from the PostgreSQL database and set a scheduled refresh using the personal gateway. Currently, the PostgreSQL data source is not supported in Enterprise gateway, you can vote and comment on this idea item: PostgreSql Datasource for Enterprise Gateway.

In Power BI Service, we are not able to change connected dataset for a report or dashboard. You can create the report in Power BI Desktop, then change the connection and point to a different server or database. Then publish it to Power BI Service.

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

Best Regards,
Qiuyun Yu

[bernardoflynn · Accepted solution]

Thanks - yes we managed to do this in Power BI desktop by editing the file as text manually and it worked after re-publishing

[Markzolotoy]

<You can create the report in Power BI Desktop, then change the connection and point to a different server or database.

Are you saying that I will need to create as many different reports as many clients I have?

[bernardoflynn]

Not sure what you mean here?

Clients as in db client? 

not sure if its the same issue I posted about. 

We wanted to change from using the postgresql db driver to using the odbc driver that uses postgresql in the background.

A subtle but big difference when using the gateway. Enterprise gateway doesn't support either so for now we're using the personal gateway