Share via

I am getting error while connecting Postgres to PowerBI

Anonymous
2024-09-13T10:52:57+00:00

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:

  1. .NET versions-7.0.302(x64) and 7.0.410(x64)
  2. .NET versions-7.0.410(x64)

3.Removed all .NET versions

4.Latest Postgres(16) and PowerBI(August 2024)

  1. Npgsql 3.2.7

6.Npgsql 4.0.10

  1. allowed inbound and outbound traffic on port 5432(where postgres is installed)

I am using Windows 11. Please help me solve this issue.

Microsoft 365 and Office | To Do | For business

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2024-09-25T23:45:17+00:00

    Anindita Mukherjee - I have been getting the same error for a month now and have tried a lot of things to get this working. please let me know if you are able to fix this issue?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-09-13T11:20:57+00:00

    Hi Anindita Mukherjee,

    Greetings. Thank you for posting the thread to our community.

    Based on your description, since our category focus on the installation of Microsoft 365 Business products, and your problem is related to Power BI, I sincerely recommend you post the question in Power BI forums - Microsoft Fabric Community, it is the specific channel handling this kind queries, members and experts are professional and will assist you further.

    Appreciate for your patience and understanding.

    Hope you having a nice day.

    Sincerely,

    Harry | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments