Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Dynamic Data Source Error in Power Query

I'm getting Dynamic Data Source error in Power Query as below : "Some data sources may not be listed because of hand-authored query"   and below is my code; How should I modify it? let BaseUr...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That's not an error, only a note.  Do you have an actual issue with the query?

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Dear  Syndicate,
Thanks for your response.

Actually, error happens when we want to refresh the dashboard on Power BI Service, as below. 
I've also attached error screenshot. 

Error Message:
"This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. " 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please read the documentation of Web.Contents - you need to use the Query parameter.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      2 years ago

      Yeah, I know  but unfortunately I don't know how exactly I should do that. Can you modify the M code that I've mentioned above?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        you would need to add a second parameter to the GetJSON function.

         

        GetJson = (Url,q) =>
let Options = [Headers=[ #"Authorization" = "Token"],Query=q],
RawData = Web.Contents(Url, Options),
Json = Json.Document(RawData)
in Json,