csv load completely crashes Feb 2019 PowerBI desktop

[Anonymous]

I have a CSV (see excerpt below) which loads without trouble on the Dec 2018 version of Power BI desktop (2.65.5313.701 (December 2018)) but completely crashes PowerBI on the current Feb 2019 version (2.65.5376.1681). One field from the CSV has the following characters for a null result "- ** None **". I'm presuming that the curent PowerBI is trying to interpret the characters in the field as some kind of command rather than as text data. I presume this is a bug that was inadvertantly created with the release of some new functionality for PowerBI. Hoping that this gets raised as a PowerBI bug for urgent bug fix, as now we have to put in a pre-processing step to remove any leading "-"s from any CSV file before loading it into PowerBI. Have replicated on both 32 and 64 bit versions, but have not yet tried the cloud version of PowerBI. Neither Tableau nor Qlik are effected by this string in a CSV file. Happy to provide the complete file to anyone who'd like to test the impact on the curent Power BI, but the following excerpt should still do the trick.

ID ,STARTDATE,STARTTIME,SIGNOFFTIME,WORKTYPE,ACTIVITY,MINUTES
1077,2-Jul-18,9:15,12:00,Normal,- ** None **,165
1078,2-Jul-18,12:30,17:15,Normal,- ** None **,285
1079,3-Jul-18,9:30,12:30,Normal,- ** None **,180
1080,3-Jul-18,13:00,16:45,Normal,- ** None **,225
1081,4-Jul-18,9:15,12:30,Normal,- ** None **,195
1082,4-Jul-18,13:00,16:15,Normal,- ** None **,195

Regards,

Jeff Popova-Clark

[v-yuezhe-msft]

@jeffpc ,

I am unable to reproduce this issue on my side using Feb 2019 version (2.65.5376.1681) and Feb 2019 version (2.66.5376.2521)



Could you please update to latest version of Power BI Desktop and then check the result? If the issue still persists, please share complete CSV file here.

Regards,
Lydia

[Anonymous]

HI All,

Here's a more comprehensive collection of info re this behaviour:

• Windows 7 Enterprise
• PowerBI  session details:

Link to datafile: https://1drv.ms/u/s!AlX_5OY8vxEsgUtgBk2kY_3TYTij

Release:

February, 2019

Product Version:

2.66.5376.1681 (19.02) (x86)

OS Version:

Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:

4.7 or later [Release Number = 461310]

Peak Virtual Memory:

1.18 GB

Private Memory:

340 MB

Peak Working Set:

482 MB

IE Version:

11.0.9600.19266

PBI_shapeMapVisualEnabled

PBI_variationUIChange

PBI_showIncrementalRefreshPolicy

Disabled Preview Features:

MIntellisense

PBI_SpanishLinguisticsEnabled

PBI_PdfImport

PBI_ColumnProfiling

PBI_PythonSupportEnabled

PBI_showManageAggregations

PBI_FuzzyMatching

PBI_EnableWebDiagramView

PBI_improvedFilterExperience

PBI_qnaLiveConnect

PBI_keyDrivers

Disabled DirectQuery Options:

TreatHanaAsRelationalSource

• Loading a small CSV file

It hangs at this point. Try to cancel and it crashes

This file is attached ( Link to file on OneDrive ) but this is not the only file that is treated like this.

The behaviour dissappears with everything identical except the version of PowerBI is November or  December 2018 PowerBI (both 32 & 64 bit versions)  January version is not yet tested.

[v-yuezhe-msft]

@Anonymous ,

Thanks for sharing the file. I make a test in Power BI Desktop March release, everything works well. Could you please update to Power BI Desktop March release?


Regards,
Lydia

[Anonymous]

We have retried in the PowerBI March 2019 version and still getting the same problem.  Just checking, we are using Windows 7 Enterprise are you testing on Win 10 installs of PowerBI?