Forum Discussion

bernardoflynn's avatar
bernardoflynn
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Change datasource

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 Post...
Need Help
  • bernardoflynn's avatar
    bernardoflynn
    10 years ago

    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's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
10 years ago

<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's avatar
bernardoflynn
Icon for Advocate I rankAdvocate I
10 years ago

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 :smileysad: