Forum Discussion
How set schedule refresh with api web
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.
2 Replies
Please show the query that calls the function.
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
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.
