Forum Discussion
Error Message wrong link to previous step
Good morning everyone,
i´m getting the following message, which says that step "Geänderter Typ 5" is linked to another request or step, when i´m open a power bi template.
When i delete the step and put it in again, it´s working for the moment, but as soon as i open the template again, the same error appears. Here is advanced code
#"Umbenannte Spalten4" = Table.RenameColumns(#"Gefilterte Zeilen",{{"Attribut", "BWA Zeile"}}),
#"Geänderter Typ4" = Table.TransformColumnTypes(#"Umbenannte Spalten4",{{"Belegdatum", type text}}),
#"Hinzugefügte benutzerdefinierte Spalte" = Table.AddColumn(#"Geänderter Typ4", "Belegdatum_2", each
if Text.Length([Belegdatum]) = 7 then Text.Start([Belegdatum],1) & "." & Text.Range([Belegdatum],1,2) & "." & Text.End([Belegdatum],4)
else
Text.Start([Belegdatum],2) & "." & Text.Range([Belegdatum],2,2) & "." & Text.End([Belegdatum],4)),
#"Geänderter Typ3" = Table.TransformColumnTypes(#"Hinzugefügte benutzerdefinierte Spalte",{{"Belegdatum_2", type date}}),
#"Der Text vor dem Trennzeichen wurde eingefügt." = Table.AddColumn(#"Geänderter Typ3", "Text vor Trennzeichen", each Text.BeforeDelimiter([#"Stapel-Nr."], "/"), type text),
#"Umbenannte Spalten5" = Table.RenameColumns(#"Der Text vor dem Trennzeichen wurde eingefügt.",{{"Text vor Trennzeichen", "Stapeldatum"}}),
#"Geänderter Typ5" = Table.TransformColumnTypes(#"Umbenannte Spalten5",{{"Stapeldatum", type date}})
in
#"Geänderter Typ5"
Can someone help me? I guess it as something to do with the if-else-statement.
10 Replies
Do you SAVE the changes after you make the edit? If you are using a TEMPLATE, I don't think you can save over it. You have to create a new file.
Yes, i save the template as a new template - isn´t it possible.
Maybe I wasn't specific in my question. When you save it, are you saving it as a TEMPLATE, then re-opening that SAME template, or are you saving it as a regular PBIX file, then opening the TEMPLATE?
No, i´m saving it as a regular pbix file and than it´s working.
But i don´t want this message, when i´m opening a template.
I suspect that your changes are NOT getting saved back to the original template. You may need to do a File > Save AS, and select Power BI Template as the TYPE. Maybe give it a new name just to be sure it is getting saved. Then open THAT template and see what happens.
That´s what i already tried a couple of times, without any luck
Instead of saving as a TEMPLATE, save it as a regular Power BI file. Then close and re-open it. If the issue is still there, then it's an issue with the Power Query coding. If the issue is resolved, then it may be related to the process of saving as a template, in which case you should open a ticket with Microsoft Support on this as it may be a bug.
OK! When i open the power bi file, it´s working fine. Seems like the problem is with the template file.
And you are absolutely positive you have tried saving this 'good' file as a NEW Template, NOT overwriting the one you started with, right? THEN opening THAT new template, and seeing if it works? Seems very suspicious that an operation that simply does one date conversion is bombing out.
Is it possibly due to the data you are trying to convert to date? Have you investigated the individual rows?
Hi SvenJ ,
Here's a article about the errer message: Power Query Errors: Please Rebuild This Data Combination
Hope it helps!
Best Regards,
Community Support Team _ kalyj
