We have an Excel file which is connected to a postgres database via PowerQuery.
PowerQuery needs npgsql provider for it. When I open file locally on my computer and try to update data - everything is ok.
I have tried to install npgsql provider on the SharePoint server and added it to Trusted data providers with no result.
So what should I do for resolve the issue? Is it possible?
Or maybe is there another way to connect an Excel file located in SharePoint to Postgres, which I do not know?