Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

database loading error (PostgreSQL database to power bi desktop)

‎06-27-2018 02:57 AM

Hi

 

When we Refresh the data in power bi desktop. it is showing below error:

"could not load file or assembly 'system.runtime.compilerservice.unsafe" . The system file cannot be opened.

 

Capture1.PNG

Labels:
Message 1 of 6
1,137 Views
0
5 REPLIES 5
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎06-27-2018 11:00 PM

Hi @Anonymous,

 

Please test in a new .pbix file, check if there is any error when creating connection to the same PostgreSQL DB.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 6
1,132 Views
0
Anonymous
Not applicable
In response to v-yulgu-msft

‎06-28-2018 02:42 AM

Hi

 

Thanks to reply,

 

I test in new pbix file , even though it is showing same error

 

Capture4.PNG

Message 3 of 6
1,128 Views
0
Anonymous
Not applicable
In response to Anonymous

‎06-28-2018 02:43 AM

when connecting postgresql with power bi it self showing error

Message 4 of 6
1,127 Views
0
Anonymous
Not applicable
In response to Anonymous

‎06-28-2018 05:24 AM

Capture5.PNG

Message 5 of 6
1,123 Views
0
v-yulgu-msft
Microsoft Employee
Microsoft Employee
In response to Anonymous

‎07-06-2018 11:23 PM

Hi @Anonymous,

 

Maybe this error is more related to your client environment. Please try to downgraded Npgsql to an older version for a test, such as 3.2.7.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 6 of 6
1,108 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All