Input string was not in a correct format

[shhemanth]

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]

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]

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... 

[Greg_Deckler]

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".