Forum Discussion

LukaszDw's avatar
LukaszDw
Copper Contributor
Oct 04, 2024

Power Query running in a loop

I have created an Excel tool that with VBA macro triggers a refresh of Power Query that sends and receives information from API. In between I have a data base that registers the requests. I can see that from time to time, especially when new user copies the file the query runs and pulls the result, however when looking into the log data base I can see new requests are coming in a loop. Switching off all Privacy Settings helps. Is there a way to save the privacy settings so that they "stay" with file rather than being restored to default whenever new user opens the file?

No RepliesBe the first to reply

Resources