Refresh Dynamic Data Source

[PhuongPham0111]

Hello everyone, I have an issue when I configure auto refresh on Power BI. I received a note:

"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.

Data source for Query1"

Here is my query of the table I want to refresh:

let

Source =

Table.AddColumn(

Table.SelectRows(

Table.FromList(

List.Numbers(0,Json.Document(Web.Contents("https://public.kiotapi.com/invoices?pagesize=100&orderBy=createdDate  ", [Headers=[Retailer="eatwell", Authorization="Bearer "& Token_Formular()]]))[total]/100, 100),

Splitter.SplitByNothing(), null, null, ExtraValues.Error),

each [Column1] >= 60000),

"Custom", Query2())

in

Source

Formular Query2():

() =>

let

Source = each Json.Document(Web.Contents("https://public.kiotapi.com/invoices?pagesize=100&currentitem=  "&Text.From([Column1])&"&orderBy=createdDate", [Headers=[Retailer="eatwell", Authorization="Bearer "& Token_Formular()]]))

in

Source

My step:

1. I create a list of number and convert it to a column.

2. I add another column based on that column with formular Query2()

I think column of number that I created is cause root.
Can you help me how to configure auto refresh with dynamic data source?

*Sorry for my bad English TT__TT

[Anonymous]

Hi  @PhuongPham0111 ,

Please refer to this link to check if there's a warning called "Some data sources may not be listed because of hand-authored queries".

Data refresh in Power BI - Power BI | Microsoft Docs

Take a look at this blog for how to use the query option available in web.contents

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code - Ch...

This is the related document, you can view this content:

Solved: Help: Dataset includes a dynamic data source error - Microsoft Fabric Community

Solved: API Pagination + Throttling + Dynamic data source ... - Microsoft Fabric Community

Best Regards,

Liu Yang

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

[lbendlin]

Read about the Query = parameter of Web.Contents.

Web.Contents - PowerQuery M | Microsoft Learn

That will make your main URL static (even without RelativePath).