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

The fix is to report this to Microsoft in the Issues forum Anonymous - this works fine if you are in Excel and import the data into Power Query. There is a bug in the Power BI PQ interpreter, and you should not have to pre-transform your data before transforming it in Power Query. 

 

Yes, to get up and running immediately, you can do the search/replace, but that is not a long term solution. I have taken the liberty to add it here. BUG: Importing data from Excel incorrectly in Powe... - Microsoft Power BI Community - please vote it up and subscribe to the thread so you can answer any questions. Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

For the last few days, I was too busy and did not get time to check all the replies. I do think that replacing the "_" is not the permanent solution. And I also appreciate that you have reported it in the issue forum.

 

Thanks

Sajib