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?
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? Read More