Forum Discussion
Schedule Refresh -Dynamic Data Source error from ODATA.Feed
Hello all,
I am unable to set up schedule refresh in Power BI Service due to error below.
As it is sensitive data, i can only provide some background about the OData.Feed. I have a Project table where I have some details for each project including ProjectLink. Accordingly, each project has different link and I am using ODATA.Feed in order to get more specific details from each project thanks to Project Link provided in the Project table, source query is below.
OData.Feed([ProjectLink] & "/_api/web/lists/getByTitle('Project items')/Items", null, [Implementation="2.0",OmitValues = ODataOmitValues.Nulls, MoreColumns= false, ODataVersion = 4])
I believe ODATA.Feed causes dynamic data source error however i was unable to solve the issue even I've found some sources on the internet. As i am not fully proficient on PowerQuery, I would be very happy if someone can provide a possible solution with details for each step to this issue.
Thank you.
5 Replies
This article goes through how to avoid that error.
Pat
Hello, I am not sure how to apply this in my case. Do you have any idea what could cause the error in my query given in first message?
Looks like you are trying to pull data from a SharePoint list. Have you tried using that connector directly? Or you can see this article for another way to pull list data that works with scheduled refresh.
Updated – Get SharePoint List Data … Fast – Hoosier BI
Pat
Anyone who can help?
