"You can't schedule refresh for this dataset because the following data sources currently don't supp

[Anonymous]

Hello , 

I hope you are doing well. 

I am desperate with the error "You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1".

I am doing an API that needs to generate a token to update the information. For this, I used a function like this: 

"(apiKey as text,userName as text)=>
let
url = "https://arcelormittal-americas-1.my.automationanywhere.digital/v1/authentication?apiKey="&apiKey&"",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username=userName,
apiKey= apiKey]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
Data = Json.Document(response),
access_token=Data[token]
in
access_token"

However, when i try to schedule the updates, it shows the error message. I watched a lot of videos and saw the solutions here but I really could not do anything. Could you please guide me with this issue? Thank you.

[v-jianboli-msft]

Hi @Anonymous ,

This error message may occur when you try to schedule a refresh for a dataset that uses a data source that is not supported by Power BI for refresh. 

If your data source is not supported by Power BI for refresh. , you may need to use a different data source or a different storage mode for your dataset. You can also check if your data source is dynamic, meaning that it changes based on parameters or user input. The Power BI service doesn’t support refreshing dynamic data sources because of how the service handles Power Query data sources. You may need to use static data sources or use DirectQuery mode instead of Import mode for your dataset.

Besides, you may get this error when you publish a dataset that has a datasource never used before in the same dataset or other datasets. In this condition, you need to click on "Discover Data Sources" in the Dataset settings page.

For more details, please refer to:

Data refresh in Power BI - Power BI | Microsoft Learn

Solved: Why power bi dont support refresh on dynamic data ... - Power Platform Community (microsoft.com)

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

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

[Anonymous]

@amitchandak , @ibarrau , @mahoneypat , @mahoneypat2 , @Anonymous , @Ritaf1983 please people, help me 🙂