cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benjamin_sasin
Resolver I
Resolver I

BUG: add new column modifies content of other columns.

I'm experiencing a strang bug, which could have been quite damaging to business here if I hadn't spotted the errors.

 

In the screenshots below, I am switching from the penultimate step in my ETL (first picture) to the last step (second picture).

 

The two steps are simply adding text columns and do not have any formula or relation to other columns at all

 

Yet in the last step (second picture) the data in columns application_state, students status, default_contact_status and--only in row 11--applied_program are overwritten with completely different data!

 

2020-01-10 (6).png2020-01-10 (5).png

 

Is there any help please?

1 ACCEPTED SOLUTION
az38
Super User II
Super User II

Hi @benjamin_sasin 

please, pay attention to the preview date (right-bottom corner of your pics) - it's completely different

so, you should understand that in Power Query Editor mode is only preview of your data.

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
az38
Super User II
Super User II

Hi @benjamin_sasin 

please, pay attention to the preview date (right-bottom corner of your pics) - it's completely different

so, you should understand that in Power Query Editor mode is only preview of your data.

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

Errr.. Why is the preview not the same for both steps of the ETL recipe? I am aware the preview of the query can be outdated, but I was assuming that the preview date would be the same for all steps.

 

Now I am trying to reproduce the situation and the preview is the same for all steps of the recipe.

 

Anyway, thank you for finding that out. I learned something.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors