Forum Discussion

SenPower's avatar
SenPower
Frequent Visitor
1 year ago
Solved

Power BI Refresh Error

Hi Guys, 

I am kinda new to M Code and trying to learn along the way. I trying to set up schdule refresh with my data set but i get the error message below..... i have also provided the Code with i run from the API. If anyone can help me to solve this issue?

Error Message = 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.

M Code = 

let
// Source
source = "https://app.*******-****.com/api/v1/service",
apiKey = ************,

 

    // Data extracting from each page

    GetPage = (PageNumber as number) =>

        let

            url = source & "?" & "page=" & Number.ToText(PageNumber),

            headers = [ #"Authorization" = "Bearer " & apiKey ],

            response = Web.Contents(url, [Headers=headers]),

            json = Json.Document(response),

            data = json[data],

            nextPage = json[meta][pagination][next_page]

        in

            if List.Count(data) = 0 then null else data,

 

    // Looping through each pages

    GetAllPages = List.Generate(

        () => [Page = 1, Data = GetPage(1)],

        each [Data] <> null,

        each [Page = [Page] + 1, Data = GetPage([Page])],

        each [Data]

    ),

 

    // Pages into Table

    AllData = List.Combine(GetAllPages)

in

    AllData

2 Replies