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
stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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.