cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jeffpc Frequent Visitor
Frequent Visitor

csv load crashing Feb 2019 powerbi completely

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

4 REPLIES 4
Community Support Team
Community Support Team

Re: csv load crashing Feb 2019 powerbi completely

Hi @jeffpc ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jeffpc Frequent Visitor
Frequent Visitor

Re: csv load crashing Feb 2019 powerbi completely

Hi @v-frfei-msft ,

 

Thanks for responding.  Here is a link to a OneDrive copy of the csv file that crashes the latest version of PowerBI on several machines here.

 

https://1drv.ms/x/s!AlX_5OY8vxEsgUlUYjpG23yaXXgr

 

 

Community Support Team
Community Support Team

Re: csv load crashing Feb 2019 powerbi completely

Hi @jeffpc ,

 

Based on my test using your file. I cannot reproduce your issue here by the same version as yours. Could you please share the screen shot of your issue, like pop-up message of something else.

 

feb.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jeffpc Frequent Visitor
Frequent Visitor

Re: csv load crashing Feb 2019 powerbi completely

Thanks @v-frfei-msft,

 

Here is the screen that is showing when PowerBI becomes completely unresponsive.  Only a Task Manager process kill of PowerBI will allow progression beyond this point.

 

https://1drv.ms/u/s!AlX_5OY8vxEsgUo9uyr4Jg0tImaL

 

Jeff Popova-ClarkPowerBI_Hangs.jpgPower BI Hangs

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 105 members 1,816 guests
Please welcome our newest community members: