Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Thanks - yes we managed to do this in Power BI desktop by editing the file as text manually and it worked after re-publishing
<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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.