Forum Discussion
Dynamic Data Sources in Power BI Service
Hi all,
I am working with a dynamic data source and the Power BI Service does not support refresh of a dynamic data source. However, I've seen a couple of posts where fetching data with Web.Contents has worked in PBI Service.
Is there any way I can modify my query to get it to work? If not, are there any alternatives/work-arounds for this issue?
Here is the query:
= let
Result = Json.Document(Web.Contents(
"URL",
[
Headers = [#"Content-Type" = "application/json", #"Method" = "POST", #"User-Agent" = "Mozilla/5.0"],
Content = Json.FromValue([ #"parameter" = "value"])
]
))
in
Result
Any help is highly appreciated.
Thanks!
- Anonymous1 year ago
Hi Anonymous
To refresh dynamic data sources in Power BI Service, you can use Web.Contents() and Relative Path parameter in it, please refer:
- Setting a scheduled refresh on a Dynamic Data Source in Power BI
- Web.Contents(), M Functions And Dataset Refresh Errors In Power BI
- Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- shafiz_pSuper User
Hi Anonymous For dynamic data source in power bi service, check out the below link :
Dynamic data source in power bi serviceHope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz - AnonymousNot applicable
Hi Anonymous
To refresh dynamic data sources in Power BI Service, you can use Web.Contents() and Relative Path parameter in it, please refer:
- Setting a scheduled refresh on a Dynamic Data Source in Power BI
- Web.Contents(), M Functions And Dataset Refresh Errors In Power BI
- Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - AnkitKukrejaSuper User
Hi Anonymous
Check this link for your problem statement:
https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/