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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Combination of Power Query Changes - Error Message

Submitted by Anonymous on ‎03-26-2019 06:25 AM

Hi,

When I do a certain combination of changes in the Power Query editor, I get a warning message on Close and Apply:

Power Query Bug.PNG

The following video demonstrates the steps to reproduce. It begins with a pbix that contains 2 product tables and a sales table from Adventure works, then "Edit Queries". 

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎03-26-2019 08:13 PM

Hi @Anonymous, 

 

Which Power BI desktop version do you run? I have tested in Power BI desktop version 2.67.5404.801 64-bit (March 2019) but not able to reproduce the issue. Please run the same Power BI desktop as ours then test again. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎03-27-2019 04:40 AM

@v-qiuyu-msft - I am also using the same version: 

 

PBI Version.PNG

 

It only happens in a very specific circumstance:

1. Get Data - click Load instead of Edit:

PBI Load vs Edit.PNG

 

2. Then proceed with the video.

 

In this scenario, the model gets loaded initially and then updated, instead of just being loaded once.

Idea Statuses