Forum Discussion

hansoc2's avatar
hansoc2
Regular Visitor
4 years ago
Solved

Error with reordered columns - data switches from text to number when refreshed

Hello, I am having an issue with a Power BI report.  I am reading from an excel file that has numbers then a letter or  "-" and another number behind it.  For these instances my data table is trying ...
  • Vijay_A_Verma's avatar
    4 years ago

    Can you give your complete query? Ideally, in your Change Type step or any step where type change is referenced, you can locate the field name and replace the type number or type int64 to type text.