Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

CmdrKeene

Power Query Editor Bug: Cannot Enable Load of Query

Submitted by Helper IV on ‎02-25-2020 01:07 PM

I have 4 queries in my Power Query editor.

I disabled load for a few of them by right-clicking the query name.

 

Now I changed my mind and want to turn it back on, but it will not allow me. I try to right-click and choose "Enable Load" from the menu, but then it warns me that disabling it will break my visuals. I am not trying to disable it, I'm trying to re-enable it.

 

I found a workaround: If I duplicate the query, the new one that appears is also disabled but I can enable that one.

 

It seems like there is a bug here.

Status: New
See more ideas labeled with:
6 Comments (6 New)
Comments
v-yuta-msft
Community Support
Community Support
‎02-25-2020 11:56 PM

@CmdrKeene ,

 

I could not reproduce this issue. The power bi desktop version on my side is 2.78.5740.861 64-bit (February 2020). Please make sure power bi desktop is the latest version.

 

Regards,

Jimmy Tao

CmdrKeene
Helper IV
Helper IV
‎02-26-2020 06:14 AM

I installed the February update before I encountered this. My about box shows version string of 2.78.5740.841 64-bit (February 2020).

 

It looks like even after a reboot it's still happening. Maybe it's related to the type of data connection it is (it's an Excel file right now but it's really a proof of concept and another one will be made that connects to SQL soon).

But yeah, the query name is in an italic font and if I right-click and choose to enable, it prompts me asking if it should disable it (but it's already disabled, I was the one that disabled it originally).

 

It's not blocking my work because for now I was able to workaround it, but I'm not sure how it got into this state.

 

screenshot.png

Anonymous
Not applicable
‎03-09-2020 01:37 PM

Hi,

 

Have you found a fix for this issue. I'm getting the same problem.

CmdrKeene
Helper IV
Helper IV
‎03-09-2020 01:41 PM

Unfortunately not, although it wasn't too terrible to just duplicate the query and enable the new one/delete the old one.

germanpp
Frequent Visitor
‎03-12-2020 01:36 PM

Hi,  I also had the same problem with version 2.78.5740.981 64-bit (February 2020). Duplicating the query, enabling the new one and deleting the old one as CmdrKeene suggested solved the issue.

 

Also I am not sure how I got into that state, and I have been trying but unfortunately can`t reproduce the issue.

JH66
Regular Visitor
‎03-18-2020 04:26 AM

I have 2.78.5740.861 64-bit (February 2020), and it's just done exactly the same to me as you describe.  I turned off Enable Load on a query and now I cannot turn it back on again.

 

Thanks for the tip on referencing - that has worked for me.

Idea Statuses