Forum Discussion
Issues with dynamic token: dynamic data sources aren't refreshed in the Power BI service, this datas
I got the solution from Curbals youtube video.
all dynamic parts must be added as query then it will work.
Json.Document(Web.Contents(DataURL,
[
RelativePath = "performance?",
Query = [
startDate=sDt,
endDate=eDt
],
Headers=[Authorization="Bearer " & Token()]
]))
Super UserAnonymous , refer if this can help
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/
Thanks amitchandak ,
If you look at the code I shared; I have already implemented the solution mentioned in the blog. I even getting the data but its not working in PBI Service due to dynamic parameter (dates).
Appreciate if you can help on that.I got the solution from Curbals youtube video.
all dynamic parts must be added as query then it will work.
Json.Document(Web.Contents(DataURL,
[
RelativePath = "performance?",
Query = [
startDate=sDt,
endDate=eDt
],
Headers=[Authorization="Bearer " & Token()]
]))
Syndicate_AdminAdministrator
Hello, I have a very similar problem when putting a dynamic hour directly in my query, could you tell me what is the link of the curbals video you are talking about?