Power BI Service - SharePoint Lists - This dataset includes a dynamic data source ERROR

For anyone else coming across this, I managed to get it working using the following code. Tested in Power BI Service and no longer get the data refresh error 🙂

let
fnGetComments = (itemId as number) as table =>
let
// Construct the dynamic portion of the URL
RelativePath = "/_api/web/lists/getbytitle('YOUR LIST')/items(" & Number.ToText(itemId) & ")/Comments()",

// Basic Web Request with RelativePath
Source = Json.Document(
Web.Contents(
"https://dnastream.sharepoint.com/sites/YOURTEAM",
[RelativePath = RelativePath,
Headers = [#"Accept"="application/json;odata=verbose", #"Content-Type"="application/json;odata=verbose"]]
)
),

// JSON Parsing
JsonData = Source[d],

// Table Transformation
Results = JsonData[results],
ConvertedToTable = Table.FromRecords(Results),

// Return Statement
OutputTable = ConvertedToTable
in
OutputTable
in
fnGetComments