Dynamic Data Sources in Power BI Service

[Anonymous]

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!

[AnkitKukreja]

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/

[Anonymous · Accepted solution]

Hi @Anonymous 

To refresh dynamic data sources in Power BI Service, you can use Web.Contents() and Relative Path parameter in it, please refer:

1. Setting a scheduled refresh on a Dynamic Data Source in Power BI 
2. Web.Contents(), M Functions And Dataset Refresh Errors In Power BI 
3. 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.

[shafiz_p]

Hi @Anonymous  For dynamic data source in power bi service, check out the below link :

Dynamic data source in power bi service 

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz