Change Type changed format

[Kheara]

Hey.. So I'm not sure this is the right place to post to get help.

I have built a number of investment models using PowerQuery. I noticed this morning that all my models are broken and lagging really badly... 

I stepped through the query editor to try see where the lagging starts and I found that as I got to 'Changed Type' it through out errors. Previous types set on Currency were no longer working. So I tried to update the column and noticed the code format changed for the function... And it isn't accepting the new format. Very strange. Was there a Change Type update recently? And how do I unsure I get the proper patch for the code, so that I don't have to rebuild all my dashboards.

It changed from type number to Number.Type

 

[Kheara]

Hi @PijushRoy ... I have built a number of investment models using PowerQuery. I noticed that all my models are lagging really badly... 

I went through the query editor step by step until I got to the 'Changed Type' step, as indicated in my picture attached above. This is where the lagging starts. Change Type, as you know, changes column types to number, integer, decimal, text, currency etc..... I noticed that the types I had set previously were no longer working.(But I haven't changed anything? The model was working fine and then I opened it again and it wasn't) So I tried to update the column and noticed the code format changed for the function... And it isn't accepting the new format. Very strange. Was there a Change Type update recently? And how do I unsure I get the proper patch for the code, so that I don't have to rebuild all my dashboards.

The highlighted yellow is the "New Function" that gets created when you try change the column type... You will clearly see that it is a different format to the other code around it.... It has changed from {Col Index, type number} to { Col Index, Number.Type} for example.... This is breaking my dashboard? Why has Microsoft changed the way that Change Type function is coded?

[PijushRoy]

Hi @Kheara 

Select the column & check the error before and after the Change type step (run same for all column especially the two you mentioned). This step is only for troubleshoot purpose, delete the step after troubleshoot

Let me know result
If you find error are there you need to rectify or remove before apply the change type steps

[PijushRoy]

Hi @Kheara 

The image you shared, is it clear
also your question is not clear for me.

Can you share better image and elaborate the issue