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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

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