Change a data source for updating data in power bi service

[guineapig]

Hi! I'm new to power bi service and have some questions. I'll be thankful for any help.

I have published a report. In that report while designing it in power bi desktop I used connection to postgresql via ODBC (localy installed version of program). I have the connection to the same db via gateway, but it uses ODBC on server with another credentials and another name etc.. How can I change data source for my report in order to make it possible to update it? 

Also one more question. I tried to recreate my report in power bi services.  But when I clicked "get data" I had to choose between local files, services, my organisation reports, azure... But what about sources I have connection to via gateway?

Thank you.

[v-danhe-msft · Accepted solution]

Hi @guineapig,

For your first issue, if you want to change the database and credentials in the report, I suggest you clear the permission and get data from your new data source again:

https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection...

For your second issue,the power bi service could not support postgresql currently, you need to get data from desktop.

Regards,

Daniel He