cancel
Showing results for 
Search instead for 
Did you mean: 

BUG: Importing data from Excel incorrectly in Power Query

Please see this thread. Power Query Changing Text Characters to Symbols - Microsoft Power BI Community - it contains a link to the user's Excel file that you can repro with

 

What is happening is when Power Query in Power BI imports the text in this Excel file, the data in being converted to ASCII symbols at the import. The user cannot modify this behavior. So data that looks like this:

edhans_0-1620398439070.png

is converted to this on the SOURCE line - no transformations were done, it was just imported incorrectly.

edhans_1-1620398492912.png

Note that if you open the Excel file and use Excel's Power Query to import the data, it is imported correctly. I have confirmed there are no formatting issues in the original excel file. copying all data to a new file as text only does not fix the issue.

 

Status: New
Comments
sajib_22
Frequent Visitor

This is really an annoying problem. This issue is not happening in Excel Power Query. Also, it seems the problem is with the latest version of Power BI.

pat_mecee
Frequent Visitor

This is a more widespread issue with the Power Query online connector for excel since 6th May.

Spent 90 minutes on a support call yesterday and was able to consistently repro the issue in dataflows online.

All data sources (web / public access) for the excel workbooks proven OK using desktop.

v-chuncz-msft
Community Support

@edhans 

 

The issue is reported internally and I will keep you posted with any updates.

CRI 240700317

v-chuncz-msft
Community Support

@edhans 

 

This seems to be fixed in the latest version of Power BI Desktop.

edhans
Super User III

Confirmed @sajib_22 

sajib_22
Frequent Visitor

The issue is fixed. Thanks...