Solved: How do I refresh JSON API file?

harryfasb6000 · ‎02-20-2020

I have a report that pulls data from a JSON API file. This API file gets updated at least once a day by a third party.
Does anyone know how I can refresh the data in my report a) manually and b) automatically?

And do I require a PRO license to do either? THANKS.

v-eachen-msft · ‎02-20-2020

Hi @harryfasb6000 ,

If you mean to refresh in desktop, you could click refresh button manually.

If you mean to refresh in service, you could set a schedule refresh. Pro license could support you to share contents with others.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

v-eachen-msft · ‎02-20-2020

Hi @harryfasb6000 ,

If you mean to refresh in desktop, you could click refresh button manually.

If you mean to refresh in service, you could set a schedule refresh. Pro license could support you to share contents with others.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

amitchandak · ‎02-20-2020

In Feb2020 release incremental refresh is generally available. You need to check for API

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Power-BI-Desktop-Update-February-2020/m-...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube