This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Powe

Hello,

I am trying to connect my weclapp account to powe bi services. But I get this error:

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.

My function is :

let
GetSalesOrders = (optional PageSize as number, optional StartDate as nullable date, optional EndDate as nullable date, optional RequiredColumns as list) =>
let
// Defaults
PageSize = if PageSize <> null then PageSize else 1000,
token = "**************",
BaseURL = "https://brandgarage.weclapp.com",

// Pagination
AllPages = List.Generate(
() => [Page = 1, Data = {}],
each not List.IsEmpty([Data]) or [Page] = 1,
each [
Data =
let
QueryParams =
if StartDate <> null and EndDate <> null then
[
pageSize = Text.From(PageSize),
sort = "-id",
page = Text.From([Page]),
#"filter=createdDate>=" = Date.ToText(StartDate, "yyyy-MM-dd"),
#"filter=createdDate<=" = Date.ToText(EndDate, "yyyy-MM-dd")
]
else if StartDate <> null then
[
pageSize = Text.From(PageSize),
sort = "-id",
page = Text.From([Page]),
#"filter=createdDate>=" = Date.ToText(StartDate, "yyyy-MM-dd")
]
else
[
pageSize = Text.From(PageSize),
sort = "-id",
page = Text.From([Page])
],

WebCall = Json.Document(
Web.Contents(
BaseURL,
[
RelativePath = "webapp/api/v1/salesOrder", // 🚨 fixed endpoint
Query = QueryParams,
Headers = [
AuthenticationToken = token,
#"Content-Type" = "application/json",
Accept = "application/json"
]
]
)
),
CurrentData = if Value.Is(WebCall[result], type list) then WebCall[result] else {WebCall[result]}
in
CurrentData,
Page = [Page] + 1
],
each [Data]
),

CombinedList = List.Combine(AllPages),
OutputTable = Table.FromList(CombinedList, Splitter.SplitByNothing(), null),

ExpandedTable =
if Table.RowCount(OutputTable) > 0 then
Table.ExpandRecordColumn(OutputTable, "Column1", Record.FieldNames(OutputTable{0}[Column1]))
else
OutputTable,

FinalTable =
if RequiredColumns <> null then
Table.SelectColumns(ExpandedTable, RequiredColumns, MissingField.Ignore)
else
ExpandedTable
in
FinalTable
in
GetSalesOrders