Forum Discussion
Refresh not working in Power BI Service
Hi LukeM ,
After a few test, I found you can use RelativePath option paramter to workacross this issue.
Full query:
let Source = Json.Document(Web.Contents("https://sdata-9f58.restdb.io", [Headers=[#"x-apikey"="beb561ce267e0bd24b1f22dbeac7eaab3b732"],RelativePath="/rest/sensor"])), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_id", "data"}, {"_id", "data"}) in #"Expanded Column1"When you update data source credentials in power bi service, it will try to enable anonymous authorization mode on 'root path' instead full url.
Regards,
Xiaoxin Sheng
Hi LukeM ,
After a few test, I found you can use RelativePath option paramter to workacross this issue.
Full query:
let
Source = Json.Document(Web.Contents("https://sdata-9f58.restdb.io", [Headers=[#"x-apikey"="beb561ce267e0bd24b1f22dbeac7eaab3b732"],RelativePath="/rest/sensor"])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_id", "data"}, {"_id", "data"})
in
#"Expanded Column1"
When you update data source credentials in power bi service, it will try to enable anonymous authorization mode on 'root path' instead full url.
Regards,
Xiaoxin Sheng
Hi Xiaoxin ,
Thanks for your help with this. I used the query code you provided and it works fine in Power BI Desktop but when published to the Service it still fails to refresh. Given this persistent problem I have decided not to use Power BI.
Thanks,
Luke
