Forum Discussion
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Powe
- 11 months ago
Your structure with RelativePath and Query is exactly the supported exception on Microsoft documents.
But you must ensure BaseURL is a literal string, not a parameterized or function-passed valueYou may try below adjusted M code (Hardcode the BaseURL string directly inside Web.Contents instead of keeping it in a variable)
WebCall = Json.Document(
Web.Contents(
"https://brandgarage.weclapp.com", // hardcoded
[
RelativePath = "webapp/api/v1/salesOrder",
Query = QueryParams,
Headers = [
AuthenticationToken = token,
#"Content-Type" = "application/json",
Accept = "application/json"
]
]
)
), - 11 months ago
Power BI Service blocks refresh for queries with dynamic URLs. Your use of Web.Contents with changing query parameters (like StartDate, EndDate, Page) makes the source dynamic.
Fix:
Make the URL structure static by keeping the same field names in the Query record, even if some values are null. That way, Power BI can validate the source at design time.
Hi HesamMontazer,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.
Hi HesamMontazer,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.