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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
joko29
Regular Visitor

Dataflow: OData source from D365 Entities: Error Message=0

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

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors