Refreshing report made from Url json api source

Hello,

I have simple use case:

Data source (Json.Document(Web.Contents with parameters Date.Now) -> transformations -> dashboard.

When importing this dashboard to PBI service it is not possible to refresh it.

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

Is there any way around this?

I explored possibility of pushing data via API but i'm not sure if transformations then happen in pbi service or pbi expects that i send fully transformed data(in c# or whatever tool)..

I would like to keep the transfromation process as is because it will be complex to implement it in c#.

Thanks in advance for any tips.

Karol