- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 something changing (not associated with the API), evertything refreshes--including the API. I am charged every time the API runs. Is there a way that I can make the queries in Power Query only refresh 1 time a day through the automated refresh, not everytime I happen to need to publish the dataset to the service. Thank you for your help.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much! I will check it out! It may be next week before I am able to do so. I really appreciate your help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the quick response. I will have to see if I can implement this.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-06-2024 08:00 AM | ||
08-23-2024 08:53 PM | |||
08-02-2024 03:58 AM | |||
05-27-2024 08:20 AM | |||
04-03-2024 04:38 AM |
User | Count |
---|---|
55 | |
54 | |
49 | |
13 | |
13 |