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 would also take a moment to thank Shahid12523 , MasonMA for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Harshitha.
- v-hjannapu11 months agoCommunity Support
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.- v-hjannapu11 months agoCommunity Support
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.