Forum Discussion
Change datasource
Thanks - yes we managed to do this in Power BI desktop by editing the file as text manually and it worked after re-publishing
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
<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?
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:
Thanks - yes we managed to do this in Power BI desktop by editing the file as text manually and it worked after re-publishing