Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"] ]))
Solved! Go to 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
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.
Thanks so much, Liu Yang!
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
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
69 | |
38 | |
26 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |