Power Query - Advanced editor

[stribor45]

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, I can hit "close and apply" to get to the report side of the Power BI. Does this "close and apply" call the API again?

[Omid_Motamedise]

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]

@Omid_Motamedise how do you store it locally or cache it? 

[stribor45]

I have multiple queries that are all in "waiting for other queries" when I click "close and apply". I am trying to isolate the problem and want to disable all of them but one but when I uncheck "Include in report refresh" and "enable load" they all keep trying to load and I can't proceed with troubleshooting since I have no idea which query is hanging

[Anonymous]

Hi @stribor45 

You can put the resource of the api to other data source first(such as excel) then connect the excel in power bi so thay you can reduce the times of calling api.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes.

What you see inside the PQ editor is a preview only, but to generate the preview the query must be called to get the data.

After you close the PQ editor, BI controls when and how often the query is called.

Andreas.

[stribor45]

So when you close the editor api endpoint is called again? I am trying to minimize how many times I call Api