Forum Discussion
Power bi schedulerefresh failure
Hello,
Im unable to refresh my power bi report due to the following error message.
Pupil+ Data
Web.Contents failed to get contents from 'https://bifrost-researchers.azurewebsites.net/api/rnd/xxxxx/XXXXXX?code=RVD23RdWyO/phlHpI7Gx/6wvAWcV43M/QrTLd2H2v3vPKVQryruYcw==' (500): Internal Server Error
Below is my M query code.
let
Source = Json.Document(Web.Contents("https://bifrost-researchers.azurewebsites.net/api/rnd/xxxxx/pupil-plus?code=RVD23RdWyO/phlHpI7Gx/6wvAWcV43M/QrTLd2H2v3vPKVQryruYcw==")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"mrn", "plot", "source", "cycleOn", "cycleOff", "cycles", "operationMode", "device", "intensity", "duration", "diameters", "roundness", "decisionSupport", "entryOn", "sessionId", "tags"}, {"mrn", "plot", "source", "cycleOn", "cycleOff", "cycles", "operationMode", "device", "intensity", "duration", "diameters", "roundness", "decisionSupport", "entryOn", "sessionId", "tags"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"cycleOn", Int64.Type}, {"cycleOff", Int64.Type}, {"cycles", Int64.Type}, {"operationMode", Int64.Type}, {"device", Int64.Type}}),
#"Expanded roundness" = Table.ExpandRecordColumn(#"Changed Type", "roundness", {"OD", "OS"}, {"roundness.OD", "roundness.OS"}),
#"Expanded diameters" = Table.ExpandRecordColumn(#"Expanded roundness", "diameters", {"OD", "OS"}, {"diameters.OD", "diameters.OS"}),
#"Expanded decisionSupport" = Table.ExpandRecordColumn(#"Expanded diameters", "decisionSupport", {"OD", "OS"}, {"decisionSupport.OD", "decisionSupport.OS"}),
#"Expanded decisionSupport.OD" = Table.ExpandRecordColumn(#"Expanded decisionSupport", "decisionSupport.OD", {"diagnosis", "alert", "direct_reflex", "consensual_reflex", "resting_diameter_dark", "resting_diameter_light", "rapd_grade"}, {"decisionSupport.OD.diagnosis", "decisionSupport.OD.alert", "decisionSupport.OD.direct_reflex", "decisionSupport.OD.consensual_reflex", "decisionSupport.OD.resting_diameter_dark", "decisionSupport.OD.resting_diameter_light", "decisionSupport.OD.rapd_grade"}),
#"Expanded decisionSupport.OS" = Table.ExpandRecordColumn(#"Expanded decisionSupport.OD", "decisionSupport.OS", {"diagnosis", "alert", "direct_reflex", "consensual_reflex", "resting_diameter_dark", "resting_diameter_light", "rapd_grade"}, {"decisionSupport.OS.diagnosis", "decisionSupport.OS.alert", "decisionSupport.OS.direct_reflex", "decisionSupport.OS.consensual_reflex", "decisionSupport.OS.resting_diameter_dark", "decisionSupport.OS.resting_diameter_light", "decisionSupport.OS.rapd_grade"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Expanded decisionSupport.OS",{{"entryOn", type datetime}})
in
#"Changed Type1"
Attaching a pic of my data source.
2 Replies
AnkitKukreja , thanks for responding. I've checked their solution and it was related to sharepoint data source. But mine is cosmos DB. Unable to get past this issue.
