Hello!
During several months everything was workig fine, all dashboards were conected to PostgreSQL. However, from past week there error appeared during refreshing data with following message: DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'
I've encountered reason, and found out that encryption was ticked on, so I did ticked off it. It resolved issue on desktop side, but in Power BI Service it still remains. I can't set autorefresh on dashboards and also can't manually refresh them. I have to republish them each time, after any changes appear in dataset, which is veeery inconvenient.
I've tried everything, creating new dashboatrds, deleting permisions for datasets, changing encryption and privacy levels.
Facing same problem.
And NO, ODBS connection isn't relevant. It's very slow and also autorefresh works as on-premises gateway, which means my computer should be always on for doing it (which is veeery inconvenient as well). And another big limitation: it doens't support DirectQuery!
I'm searching for any resolution couple of days, but only I found out, that this issue appeared years ago, and still remains unresolved. Is there any updates, or I should moved to Tableau?
P.S don't sent this link:
https://community.fabric.microsoft.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the...
it's useless
