Forum Discussion
Unable to do refresh data in data flow
I am unable to refresh data flows below is the error i am getting Data format error:input couldn't recognised as a valid excel document Able to refresh in power query
Hi Anonymous ,
Did you check the Applied Steps in Query Editor?
Typically, a step "Changed Type" is created when importing data from Excel.Please try to adjust the generated code to switch the data type to Text.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.