Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

Power Query - Advanced editor

In my power query editor, I have a query that calls API, and as I hit "done" I can see the dots at the top, which tells me the query is running. After a minute or so I can see my data, At this point,...
Need Help
Omid_Motamedise's avatar
Omid_Motamedise
Icon for Super User rankSuper User
2 years ago

When you hit "close and apply" in Power BI after editing a query that calls an API, Power BI will re-run the query, which means the API will be called again. This is because Power BI needs to ensure that the data being loaded into the data model is up-to-date based on the current query logic. If you want to avoid making multiple API calls, consider caching the data or storing it locally after the initial call, depending on your use case and data freshness requirements.

  • stribor45's avatar
    stribor45
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Omid_Motamedise how do you store it locally or cache it?