Forum Discussion

LukeM's avatar
LukeM
Regular Visitor
7 years ago
Solved

Refresh not working in Power BI Service

Hi, I am using Power BI Desktop to source data from a database I have in the cloud.  This works perfectly and refreshes on command.  I then publish it to the Power BI Service.  However, when I open ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

LukeM's avatar
LukeM
Regular Visitor
7 years ago

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