Relationships between tables and PowerBI crash SQLDUMPER.exe

Status: Accepted
by lassuied Frequent Visitor on ‎12-28-2017 09:18 AM

Hello everyone, 

 

Since the new December version has been released, I keep having crashes of Power BI over and over trying to link two tables... 

 

As soon as I want to create the link (drag and dropping a dimiension to a table to another table) the windows terminal opens with SQLDUMPER.exe and close/crash Power BI.

 

I have never experienced this before the last release.

 

Thank you for your help

Status: Accepted
Comments
by jmbull Visitor
on ‎12-28-2017 10:42 AM

Same issue here. Trying to create a relationship between two text columns. One table is very small, the other is ~400k rows.

by jellis007 Visitor
on ‎12-28-2017 11:26 AM

Ditto. Same problem here with two tables that are ~10K and ~100K rows, respectively.

by Moderator v-qiuyu-msft
on ‎12-28-2017 10:22 PM

Hi all,

 

The issue has been reported internally before: CRI 54333777. The fix will be released on January. 

 

Best Regards,
Qiuyun Yu 

by Vicky_Song Established Member
on ‎12-28-2017 10:23 PM
Status changed to: Accepted
 
by PAPutzback Frequent Visitor
on ‎01-02-2018 02:32 PM

Sooooo, how do we roll back to the November 2017 version?

by oberthju Frequent Visitor
on ‎01-02-2018 09:48 PM

Same issue for me with december version. Refreshing tables more than 200 000 lines, SQLdump black window appearing and quickly disapearing then getting this message on the request window : powerbi desktop failed to save modifications to the server. Rolling back to november version is refreshing fine with exactly the same .pbix file. See error message in French below. This bug is very impacting. Hope you will  correct it in January.

error powerbi.png

by ioshiames Member
on ‎01-03-2018 11:54 AM

same thing here. gives a quick sqldumper message then crashes when drawing the relationship between two tables. 

by syam_v Regular Visitor
on ‎01-04-2018 04:47 PM

I also observed this. But as per my analysis when a new relationship is created between two tables and relationship turns out to be many to many then SQLDumper.exe opens up and PowerBI crashes.

 

Team, can you look into this.

by zenatti Visitor
on ‎01-04-2018 05:41 PM

You can roll back to the previous version using the website below:

 

https://zenatti.net/2017/07/04/power-bi-previous-versions/

 

Thanks,

 

Sergio

by jellis007 Visitor
on ‎01-05-2018 07:20 AM

Thanks @zenatti! #hero

Idea Statuses