Sharepoint List refresh with additional API custom query. Can't refresh on Report Server

Hi,

I'm trying to create a sharepoint page with a List that users can update, and a dasboard that summarises it. The dashboard also includes data regarding version history, which I collect using a API query.

• Used this method for API query to get update history 
• Used this method to get unique list of updates to field i'm interested in.

So far, so good. All works nicely in desktop.

Upload it to Power BI for the sharepoint page, try and refresh or schedule. Get error "The dataset includes a dynamic data source". I assume this is due to the API query into sharepoint to get the version history.

• Searching Power BI community just leads me to Chis Webbs 2016 blog post
• It's quite old now
• It's 3rd party API
• I don't see lots of other people having the issues when search api for sharepoint, which leads me to suspect there's a new functional way of doing it?
• It seems very bizarre that can't query and refresh from Sharepoint. Is this really still the solution?

Edit:

• Is this even the correct solution to the issue in first place?
• I'm trying to work out why theirs doesn't then does work compared to mine, and how I edit mine to make it work?
• Is it because of the parameters on the query that it's not working? I can hardcode the sharepoint path, but can't see how I would edit the query so that the each Items.Id can be passed into it.

Edit2:

The refresh error messsage

Guessing this what it means by dynamic data. Using the custom query to get version history for all items.id