Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
blackanese27
Frequent Visitor

Changes made in Transform Sample File not changing in my Master Query

Hi Folks! I'm working on wrapping up a query I did and am having a hard time understanding why the changes I've made in the Transform Sample File aren't reflecting the master query that the Sample File is taken from. It's the only set of edits where I've noticed the changes weren't being made. The first image below reflects the data type changes that I made (as a date data type).Move In Date Transform Sample File.png

 

The below image is what I'm seeing in the Master QueryMove in Date Master Query.png

 

Thanks for the help!

3 REPLIES 3
Chrisjr
Helper IV
Helper IV

Hi @blackanese27  I am having the same issue here. 

Did you manage to solve it ?

JP_OWR
New Member

I have a similar problem, did not get the warning and can see the steps in the function but they are not been applied. It seems to mainly be change of type functions it occurs.

m_dekorte
Super User
Super User

Hi @blackanese27,

 

Did you by any chance open the function query "Transform File" in the advanced editor?

If so, you should have seen this prompt.

m_dekorte_0-1683883356036.png

 

Create a new connection to the folder, copy your steps from the "Transform Sample File" into the new "Transform Sample File (2)" query and see if these are now reflected in the new result/output query.

 

Ps. If this helps solve your query please mark this post as Solution, thanks!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors