Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

OLE DB or ODBC error: Specified cast is not valid

Hi -

I received the following error message when attempting to a table to Power BI Desktop.  "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error:  Specified cast is not valid..'.

 

I am attempting to access a PostgreSQL database via the Power BI Desktop version on the Windows 7 OS. 

 

The last attempt was done with one table that is small in size.  Several other attempts were made with much larger tables where the same error message was received with those attempts.

 

Any help is much appreciated.

 

4 REPLIES 4
alazarin
New Member

I've had the same error so I updated to the latest version of Power BI Desktop and now the error is gone

Just updated my Power BI Desktop and yes, the problem is gone!  

AthenaIntel
Frequent Visitor

I am having the exact same issue.  A simple walk through on solution is GREATLY appreciated!

 

Thanks

I have the same error

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.