Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Issues with dynamic token: dynamic data sources aren't refreshed in the Power BI service, this datas

Hi all, I trying to fetch data via API which needed dynamic token; I am successful in retriving data in Power BI desktop but when I publish the same on Power BI Service I am getting an error (when r...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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()]
    ]))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    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?