Forum Discussion

islandtime's avatar
islandtime
Frequent Visitor
9 years ago

Microsoft.Mashup.Evaluator.Interface.ErrorException: Specified cast is not valid.

Hi    I have connected to a Postrgre database, and can edit the tables; but when loading a table, I get the following (lengthy) error:   Error Message: Specified cast is not valid.   Stack Tra...
Need Help
dearwatson's avatar
dearwatson
Continued Contributor
9 years ago

Looks like a data type error, I think PowerBi doesn't support some data types.. like binary etc..

 

do you have funky data types in the table?


Cheers

Greg

sherryliu's avatar
sherryliu
Advocate I
9 years ago

HI Greg,

I had the same error loading data from Postgre into PowerBI (preview worked fine). I tried to load table with data and without. All failed.  What could I do to solve this? 

Best,

Sherry