cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SvenJ
Helper III
Helper III

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.

 

fehlermeldung.PNG

 

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 10
v-kalyj-msft
Community Support
Community Support

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

ToddChitt
Post Prodigy
Post Prodigy

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?

ToddChitt
Post Prodigy
Post Prodigy

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.

SvenJ
Helper III
Helper III

That´s what i already tried a couple of times, without any luck

ToddChitt
Post Prodigy
Post Prodigy

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.

ToddChitt
Post Prodigy
Post Prodigy

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.

SvenJ
Helper III
Helper III

Yes, i save the template as a new template - isn´t it possible. 

ToddChitt
Post Prodigy
Post Prodigy

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.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!