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

Edit Query Freezing

I had just installed Power BI Desktop. I have 32-bit version of Office 2010 and I installed the 32-bit version of BI. Everytime I upload an excel file (be it a 97-03 or newer) and try to apply multiple filters or try to "Remove Rows", the whole program freezes or times out. No error or message shows up no matter how long I let it sit, and deleting 1 row shouldn't take 15 minutes. Also, it isn't my computer that freezes, but Power BI.

 

I have seen a few of the fixes that involve unchecking all autodection of relationships and not allowing preview of data, and I still ran into problems.

 

Also, I have run the same queries through Power Query in excel and there are no problems. So something has to be going on with Power BI Desktop, not the file or my computer.

 

Any help would be greatly appreciated, Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft pqian
Microsoft

Re: Edit Query Freezing

@ajulius, maybe the same issue as 

http://community.powerbi.com/t5/Desktop/Power-BI-Desktop-July-2016-bug/td-p/54824/highlight/false

 

a QFE is on its way. Subscribe to that thread for updates.

View solution in original post

3 REPLIES 3
Microsoft pqian
Microsoft

Re: Edit Query Freezing

@ajulius, maybe the same issue as 

http://community.powerbi.com/t5/Desktop/Power-BI-Desktop-July-2016-bug/td-p/54824/highlight/false

 

a QFE is on its way. Subscribe to that thread for updates.

View solution in original post

ajulius Frequent Visitor
Frequent Visitor

Re: Edit Query Freezing

Thank you, I don't know how I missed that. I must have done several searches then gone through 20 pages on the forums before I posted my problem.

oblachubs New Member
New Member

Re: Edit Query Freezing

Edit Queries is crashing in the newest version of MS Power BI for me:

Version: 2.58.5103.501 64-bit (May, 2018)

As soon as I click it the screen turns white and the app closes.   I am using 2 spreadsheets on a network file share. Everything else works like data source settings and refresh. Please advise.  Thanks.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors