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.

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!