Refreshing report made from Url json api source

[atomek1000]

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

[v-yuezhe-msft · Accepted solution]

@atomek1000,

It doesn't support to refresh the data source that is dependent on parameter in Power BI Service. Please vote up the following ideas.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10927416-web-contents-should-supp...

In addition, please check if the workaround works in your scenario.

Regards,

Lydia

[atomek1000]

Workaround is perfect 🙂

I passed correct Url and changed parameters in [Query] part. I only use Date functions but i suppose it will work for everything else.

Thank you very much