Schedule Refresh -Dynamic Data Source error from ODATA.Feed

[GrimReaperX]

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.

[GrimReaperX]

Anyone who can help?

[ppm1]

This article goes through how to avoid that error.

Using OData.Feed And The Query Option To Avoid The Dynamic Data Sources Error In Power BI - Chris We...

Pat

[GrimReaperX]

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?

[ppm1]

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

[GrimReaperX]

Hello,

I have SharePoint list where I have a column where you can see link for each project. However, there is also another column where I have link extension and I can get details of project with this extension. I have more than 200 rows so links for eack project with extension where you can pull project detail columns. 
I am not sure how can I connect multiple project links within this table ? Is there any connector where I can get details of my projects based on links on the table?

So that i can stop usin Odata because of schedule refresh issue

Thanks