I am getting the below error while connecting Postgres to PowerBI-"Dimension - Calendar Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'".
I have tried the below options:
- .NET versions-7.0.302(x64) and 7.0.410(x64)
- .NET versions-7.0.410(x64)
3.Removed all .NET versions
4.Latest Postgres(16) and PowerBI(August 2024)
- Npgsql 3.2.7
6.Npgsql 4.0.10
- allowed inbound and outbound traffic on port 5432(where postgres is installed)
I am using Windows 11. Please help me solve this issue.