Forum Discussion
Dataset includes dynamic source - wont refresh in Power BI Service
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"] ]))
- Anonymous3 years ago
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.
2 Replies
- AnonymousNot applicable
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.
- AnonymousNot applicable
Thanks so much, Liu Yang!