Input string was not in a correct format

shhemanth · ‎03-04-2020

Hi,

While importing a table into Dataflow, am getting the error "Input string was not in a correct format". I am connecting to Oracle Database.

tankepaus · ‎02-14-2022

I encountered this when querying a view in SQL and the underlying table had changed a data type for a column. Querying the view in SQL was no problem - it reported no error. But just running an ALTER on the view, without changing anything, solved the problem as it updates the data types from the underlying table(s).

v-diye-msft · ‎03-04-2020

Hi @shhemanth

I have tested on my side, but not reproduce the issue. And I also looked through a lot of documents, there is only one similar post and its solution get from Microsoft Support :

https://community.powerbi.com/t5/Desktop/Input-string-was-not-in-a-correct-format-Unexpected-error-o...

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Greg_Deckler · ‎03-04-2020

Not a lot to go on. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...