Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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
Super 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
    Administrator
    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
      Super User
      2 years ago

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

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Administrator
        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?