Dataset includes dynamic source - wont refresh in Power BI Service

[stribor45]

I don't understand what I am doing wrong. Everything works in Power BI Desktop but it won't refresh in service. I followed the tutorial on Chris Webbs's blog but this issue persists. I have broken down parts of the URL as per this tutorial but it just won't refresh in service. Does anyone have any suggestions as to what else I can try to make this work?

Thanks

     apiURL = "https://something.comm.io",
     rel = "//livedata/data:search",
     headers = [Authorization="Basic myKey",#"Content-Type"="application/json", #"Accept"="application/json"],
     postData = Text.ToBinary("{my json data here}"}


            Source = Json.Document(Web.Contents(Url, [Headers=headers, Content = postData, RelativePath = rel, Query=[include = "session", siteCode = "1234567", pageIndex = p, pageSize = "500"] ])) 

 

[MSM2023]

Thanks so much, Liu Yang!

[Anonymous · Accepted solution]

Hi  @stribor45 ,

Please refer to this link to check if there's a warning called "Some data sources may not be listed because of hand-authored queries".

Data refresh in Power BI - Power BI | Microsoft Docs

Take a look at this blog for how to use the query option available in web.contents

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code - Ch...

This is the related document, you can view this content:

Solved: Help: Dataset includes a dynamic data source error - Microsoft Fabric Community

Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric Community

Solved: Power BI Service with dynamic data sources - Microsoft Fabric Community

Solved: Error due to a query that doesn't exist - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.