Share
ReportAn excel import (Locations entity for My Data) file that used to work (I have uploaded it many times before) is failing with the following errors:
---------- Message ----------
Request failed with status code 500
---------- Stack ----------
Error: Request failed with status code 500
at e.exports (content.powerapps.com/.../main.5fef0f11.js:2:991822)
at e.exports (content.powerapps.com/.../main.5fef0f11.js:2:991662)
at XMLHttpRequest.b (content.powerapps.com/.../main.5fef0f11.js:2:990210)
---------- Session ID ----------
bc29b490-dba5-11ed-8c0b-9bfe63f996d6
---------- Mashup script ----------
section Section1;
shared Sheet1 = let
Source = Excel.Workbook(Web.Contents("junctionsolutions-my.sharepoint.com/.../Microsoft Power Query/Uploaded Files/My Data Locations 4.xlsx"), null, true),
#"Navigation 1" = Source{[Item = "Sheet1", Kind = "Sheet"]}[Data],
#"Promoted headers" = Table.PromoteHeaders(#"Navigation 1", [PromoteAllScalars = true]),
#"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"LocationId", type text}, {"LocationName", type text}, {"LocationDescription", type text}, {"LocationAddressLine1", type text}, {"LocationAddressLine2", type any}, {"LocationCity", type text}, {"LocationStateId", type text}, {"LocationPostalCode", Int64.Type}, {"LocationLatitude", type number}, {"LocationLongitude", type number}, {"LocationDatum", type any}, {"LocationElevation", type any}, {"LocationElevationUnitOfMeasureId", type any}, {"GlobalLocationNumber", type any}, {"TimezoneId", type any}, {"DaylightSavingsTimeObservedIndicator", type any}, {"CountryId", type text}}, "en"),
#"Mapped to CDM" = Cdm.MapToEntity(#"Changed column type", {{"LocationId", "LocationId", type text}, {"LocationName", "LocationName", type text}, {"LocationDescription", "LocationDescription", type text}, {"LocationAddressLine1", "LocationAddressLine1", type text}, {"LocationAddressLine2", "LocationAddressLine2", type text}, {"LocationCity", "LocationCity", type text}, {"LocationStateId", "LocationStateId", type text}, {"LocationPostalCode", "LocationPostalCode", type text}, {"LocationLatitude", "LocationLatitude", type number}, {"LocationLongitude", "LocationLongitude", type number}, {"LocationDatum", "LocationDatum", type text}, {"LocationElevation", "LocationElevation", Int64.Type}, {"LocationElevationUnitOfMeasureId", "LocationElevationUnitOfMeasureId", type text}, {"GlobalLocationNumber", "GlobalLocationNumber", type number}, {"TimezoneId", "TimezoneId", type text}, {"DaylightSavingsTimeObservedIndicator", "DaylightSavingsTimeObservedIndicator", type logical}, {"CountryId", "CountryId", type text}}, null, "Location")
in
#"Mapped to CDM";
section Section1;
shared Sheet1 = let
Source = Excel.Workbook(Web.Contents("junctionsolutions-my.sharepoint.com/.../Microsoft Power Query/Uploaded Files/My Data Locations 3.xlsx"), null, true),
Navigation = Source{[Item = "Sheet1", Kind = "Sheet"]}[Data],
#"Promoted headers" = Table.PromoteHeaders(Navigation, [PromoteAllScalars = true]),
#"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"LocationId", type text}, {"LocationName", type text}, {"LocationDescription", type text}, {"LocationAddressLine1", type text}, {"LocationAddressLine2", type any}, {"LocationCity", type text}, {"LocationStateId", type text}, {"LocationPostalCode", Int64.Type}, {"LocationLatitude", type number}, {"LocationLongitude", type number}, {"LocationDatum", type any}, {"LocationElevation", type any}, {"LocationElevationUnitOfMeasureId", type any}, {"GlobalLocationNumber", type any}, {"TimezoneId", type any}, {"DaylightSavingsTimeObservedIndicator", type any}, {"CountryId", type text}}, "en"),
#"Mapped to CDM" = Cdm.MapToEntity(#"Changed column type", {{"LocationId", "LocationId", type text}, {"LocationName", "LocationName", type text}, {"LocationDescription", "LocationDescription", type text}, {"LocationAddressLine1", "LocationAddressLine1", type text}, {"LocationAddressLine2", "LocationAddressLine2", type text}, {"LocationCity", "LocationCity", type text}, {"LocationStateId", "LocationStateId", type text}, {"LocationPostalCode", "LocationPostalCode", type text}, {"LocationLatitude", "LocationLatitude", type number}, {"LocationLongitude", "LocationLongitude", type number}, {"LocationDatum", "LocationDatum", type text}, {"LocationElevation", "LocationElevation", Int64.Type}, {"LocationElevationUnitOfMeasureId", "LocationElevationUnitOfMeasureId", type text}, {"GlobalLocationNumber", "GlobalLocationNumber", type number}, {"TimezoneId", "TimezoneId", type text}, {"DaylightSavingsTimeObservedIndicator", "DaylightSavingsTimeObservedIndicator", type logical}, {"CountryId", "CountryId", type text}}, null, "Location")
in
#"Mapped to CDM";
All responses (
Answers (
291,280
