Hello,
i have simple code to get tables via ODATA and after getting the tables, I combine the tables (vertical).
The code was working since a long time. Since a view weeks, I have trouble with a specific dataflow (others still work fine with the same principles).
Any hint to avoid this?
=================================================================
Code from one tabkle ( I have 4 with the same logic):
let Quelle = OData.Feed(D365_System&"/CustomerProductDescriptionsV2?cross-company=true", null, [Implementation = "2.0"]), #"Entfernte Spalten" = Table.RemoveColumns(Quelle, {"ReleasedProduct", "Customer"}), #"Hinzugefügte benutzerdefinierte D365EntityNoID" = Table.TransformColumnTypes(Table.AddColumn(#"Entfernte Spalten", "D365EntityNoID", each [ItemNumber]), {{"D365EntityNoID", type text}}), #"Hinzugefügte benutzerdefinierte EcoResReleasedProductCreationV2Entity" = Table.TransformColumnTypes(Table.AddColumn(#"Hinzugefügte benutzerdefinierte D365EntityNoID", "D365MappingEntityID", each "SalesCustomerProductDescriptionV2Entity"), {{"D365MappingEntityID", type text}}), #"Andere Spalten entpivotiert" = Table.UnpivotOtherColumns(#"Hinzugefügte benutzerdefinierte EcoResReleasedProductCreationV2Entity", {"dataAreaId", "D365EntityNoID", "D365MappingEntityID"}, "Attribut", "Wert"), #"Geänderter Spaltentyp" = Table.TransformColumnTypes(#"Andere Spalten entpivotiert", {{"Wert", type text}})in #"Geänderter Spaltentyp" ===========================================================================
Code to combine (reduced to to tables to simplify the case:
let Quelle = Table.Combine({#"EcoResReleasedProductCreationV2Entity (vertical)", #"EcoResReleasedProductV2Entity (vertical)", #"SalesCustomerProductDescriptionV2Entity (vertical)"}),
MyTable = Quelle{[Item="MyTable"]}[Data], BufferMyTable = Table.Buffer(dbo_MyTable),
#"Geänderter Spaltentyp" = Table.TransformColumnTypes(Quelle, {{"Wert", type text}})in #"Geänderter Spaltentyp" ========================================================== Error Message:
ApiRequest error with status 0
---------- Stapel ----------
ApiResponseError: ApiRequest error with status 0
at g.handleErrorEvent