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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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