Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query Changing Text Characters to Symbols

Hi, I'm facing a very weird problem. I have a PBI report where my source is from an Excel file. In the file, there is a column (Huawei cell Name) that has some values like "DHK_X0034_1", "DHK_X2267_...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    As advised, the best course of action here was to post this in the Issues forum where it was seen by the MS team on the Powery product, where it was fixed by the May 2021 release. marking this as the solution to this thread can be seen as solved.

edhans's avatar
edhans
Community Champion
5 years ago

Well, I am stuck. I cannot figure out why it is doing this. If I bring the data into Excel's Power Query it works fine, but not in PQ in Power BI. I have also copied and pasted the values to a new workbook at tried it that way - it still fails.

 

I have confirmed there are no unusual ASCII characters causing this too. ImkeF have you ever seen anything like this? The excel and PBIX file are linked to above.

 

I am going to think about it some more, and maybe someone else will have a solution, but at this point I'd be inclined to post this to the Issues forum as a bug.

edhans's avatar
edhans
Community Champion
5 years ago

Anonymous Please let me know if you have any trouble creating a post in the Issues forum. The MS Power BI team monitors that forum and should respond relatively quickly.