Forum Discussion
Solved
Refresh a query with an API only one time a day through automated refresh schedule.
HI. I have a power bi report that has a weather API. I currently have an auto refresh one time every day. However, when I am working in the desktop and need to publish the dataset due to somethi...
Hi TJohnsonOK ,
If you haven't used flow before, I made a simple sample for you.
//Create a SharePoint list as the dataset to save the outputs from calling the API
Best Regards,
Wearsky
No. You would need to decouple the API call by (for example) running a Power Automate Flow that is scheduled to run once a day, calls the API, and stores the response as JSON in a OneDrive. Then point your semantic model to that JSON file for refresh.
Thank you for the quick response. I will have to see if I can implement this.