Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

"Dataset includes a dynamic data source" Dynamic date in Web Source (No API)

I can't refresh dataset once it's been published because of this error. I cannot seem to find a workaround that suits my needs.   The below example is grabbing a table from the web successfully in ...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi Anonymous 

 

The root URL can't be dynamic, it needs to be a fixed string.  You can supply dynamic parts of the URL using RelativePath like this

Origen = Json.Document(
    Web.Contents(
        "https://www.example.com/data/type/date:", 
        [RelativePath=Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd"]
    )
),

 

 

regards

 

Phil