Forum Discussion

illmatic's avatar
illmatic
Frequent Visitor
5 years ago
Solved

Automatic Refresh on dynamic data sources - SharePoint

Apologies if this question has been asked ad nauseum.  I'm having difficulty trying to figure out how to transition a dynamic data query made to SharePoint API to Power BI Service. The query works f...
Need Help
  • illmatic's avatar
    illmatic
    5 years ago

    Hi Stephen,

    I think you may have misinterpreted the question.  This does not have to do with credentials; there is a dynamic query at the 'GetList' action.   I am unable to schedule an automated refresh due to this reason and received an error stating as much. 

    In any case, I was able to resolve by using Chris Webb's method of Json.Document source and Web.Contents to use relative paths so that the Source Url could continue to be read and I can iterate throughout all my subsites and aggregate all lists.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi illmatic ,

 

From your query, you can see that your data source is OData. The report of OData data source is published to Power BI Service without a gateway. You only need to have the correct credentials to configure the scheduled refresh.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • illmatic's avatar
    illmatic
    Frequent Visitor
    5 years ago

    Hi Stephen,

    I think you may have misinterpreted the question.  This does not have to do with credentials; there is a dynamic query at the 'GetList' action.   I am unable to schedule an automated refresh due to this reason and received an error stating as much. 

    In any case, I was able to resolve by using Chris Webb's method of Json.Document source and Web.Contents to use relative paths so that the Source Url could continue to be read and I can iterate throughout all my subsites and aggregate all lists.

    • SDM_1997's avatar
      SDM_1997
      Helper II
      4 years ago

      Hi!
      I am also stuck at a similar position. And I am also using the Odata.Feed() in the URL. And I am unable to understand how to implement Json.Document ; Web.Contents  with this Odata.Feed. Like should I keep it as it is or replace it with Web.Contents or something?
      If it is possible, then can you reply with your updated query which includes "Json.Document ; Web.Contents" in the query?

      Thanks in advance!

    • CLTJSDUDE82's avatar
      CLTJSDUDE82
      Frequent Visitor
      3 years ago

      can you share the link to the "Chris Webb's method of Json.Document source and Web.Contents" thanks