'The remote certificate is invalid according to the validation procedure on Power BI Online Website

[LuisNguyen]

Hi, Folks

I would like to share an issue that happens on Power BI online website. Currently, I have an account to use Power BI for both versions Online and Desktop.

With Power BI Desktop, after establishing an RDS certificate and then connection work wells with Amazon RDS. Here is example

In the Power BI Online website https://app.powerbi.com/groups/be0facec-79ca-4833-b4a4-85aeb32e497e/dataflowAuthoring.

I can't establish a connection because encounter the same issue on my Desktop. So, can you help me to fix it issue and give me any guidelines for it?

Here is the screenshot as above, please help me to take a look. 

@Tuan_nguyen@datahouse.com

[v-xiaoyan-msft · Accepted solution]

Hi @LuisNguyen ,

To make the connection, take the following steps:

1. Select the PostgreSQL database option in the connector selection.

2. In the PostgreSQL database dialog that appears, provide the name of the server and database.

   

3. Select the name of the on-premises data gateway you want to use.

4. Select the Basic authentication kind and input your PostgreSQL credentials in the Username and Password boxes.

5. If your connection isn't encrypted, clear Use Encrypted Connection.

6. Select Next to connect to the database.

7. In Navigator, select the data you require, then select Transform data to transform the data in Power Query Editor.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaoyan-msft · Accepted solution]

Hi @LuisNguyen ,

To make the connection, take the following steps:

1. Select the PostgreSQL database option in the connector selection.

2. In the PostgreSQL database dialog that appears, provide the name of the server and database.

   

3. Select the name of the on-premises data gateway you want to use.

4. Select the Basic authentication kind and input your PostgreSQL credentials in the Username and Password boxes.

5. If your connection isn't encrypted, clear Use Encrypted Connection.

6. Select Next to connect to the database.

7. In Navigator, select the data you require, then select Transform data to transform the data in Power Query Editor.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[LuisNguyen · Accepted solution]

That's right to connect Amazon RDS via app power bi online. We need data gateway and install Npqsql-4.0.10. Here is my solution for that. https://flagtick.com/snippets/use-power-bi-gateway-to-connect-app-power-bi-website

Thank you for your support.