How set schedule refresh with api web

[Anonymous]

Hello, I have an error message with the impossibility of programming the refresh of my dataset.

"You cannot schedule refresh for this dataset, because the following data sources do not support refresh at this time:"

I am using a web api with a token system. See the screen

My function:

= (tableImport) =>
let
Source = Json.Document(Web.Contents("https://stafiz.net/api/" & tableImport, [Headers=[Authorization="Bearer " & ApiToken]])),
ConvertTable = Table.FromRecords({Source}),
Develop = Table.ExpandListColumn(ConvertEnTable, "data"),
KeepData = Table.SelectColumns(Developer,{"data"})
in
KeepData

And this with my "ApiToken" parameter in text type.

What is the workaround of the problem please? I came across this article but my technical level is not enough to understand what to do. Thanks a lot for your help.

[v-henryk-mstf]

Hi @Anonymous ,

According to the error message, it means that refreshing this type of data source is not supported in the Power BI service.

As a workaround, what you can do is to use the relative path option, refer to the following blog.

Setting a scheduled refresh on a Dynamic Data Source in Power BI | by dataninja | DataDrivenInvestor

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Or check if this feature option is disabled.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

Best Regards,
Henry

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

[lbendlin]

Please show the query that calls the function.