Forum Discussion
Solved
Dynamic Querying with Static URL and Headers
Gooday, I have a query that needs to be able to schedule refresh. The following query in desktop can manually refresh: let
day = DateTime.LocalNow()
Source = Json.Document(Web.Conte...
Hi k13,
Try using RalativePath similar to this:Re: PowerBI - Relative Path - Microsoft Power BI Community
Cheers,
John
Hi k13,
Try using RalativePath similar to this:Re: PowerBI - Relative Path - Microsoft Power BI Community
Cheers,
John
Yes, thank you!! This is the code I used to make this work from that link.
let
day = DateTime.LocalNow()
Source = Json.Document(Web.Contents("URL"&day,
[RelativePath = day,
Headers =
[Accept="application/json",
Authorization="token"
]]))
in
#"Source"