Forum Discussion
Refresh published report in service
Community ChampionHi david_obrien1 ,
I don't know where you got that from, but there is absolutely no limitation of web refresh with regards to the JSON format. Any limitation must come from something else.
If you google problems with dynamic datasources Power Query refreshes you find a couple of hints and workarounds.
It's probably due to the fact that your query is different to what you have posted above.
It's literally in the error message that says that the query doesn't support this.
Or what does that error message mean?
There is a table on learn.microsoft.com that also shows all the connectors and says that web and JSON don't support refresh.
The published query is identical to the one I posted. Not sure why you'd think it's different.
I'm confused that the error says it's not possible and you saying it is possible.
There is a table on learn.microsoft.com (which I can't find right now, I'm on the phone) that also shows all the connectors and says that web and JSON don't support refresh.