Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SenPower
New Member

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

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @SenPower ,

In most cases, Power BI semantic models that use dynamic data sources can't be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service, such as when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

To determine whether your dynamic data source can be refreshed, open the Data source settings dialog in Power Query Editor, and then select Data sources in current file. In the window that appears, look for the warning message, as shown in the following image:

vjunyantmsft_0-1728532896337.png


Refer to, which describes how to set a scheduled refresh on a dynamic data source in Power BI:
https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-... 

Here are some posts where other users have solved the same problem. You can refer to the solutions:
Solved: Help: Dataset includes a dynamic data source error - Microsoft Fabric Community
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric Community
Solved: Power BI Service with dynamic data sources - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
SenPower
New Member

Thank you! It worked. 
I have just set up the paths correctly using RelativePath. 


v-junyant-msft
Community Support
Community Support

Hi @SenPower ,

In most cases, Power BI semantic models that use dynamic data sources can't be refreshed in the Power BI service. There are a few exceptions in which dynamic data sources can be refreshed in the Power BI service, such as when using the RelativePath and Query options with the Web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

To determine whether your dynamic data source can be refreshed, open the Data source settings dialog in Power Query Editor, and then select Data sources in current file. In the window that appears, look for the warning message, as shown in the following image:

vjunyantmsft_0-1728532896337.png


Refer to, which describes how to set a scheduled refresh on a dynamic data source in Power BI:
https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-... 

Here are some posts where other users have solved the same problem. You can refer to the solutions:
Solved: Help: Dataset includes a dynamic data source error - Microsoft Fabric Community
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric Community
Solved: Power BI Service with dynamic data sources - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors