Forum Discussion
Input string was not in a correct format
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.
3 Replies
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".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 :
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).
