Forum Discussion
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?
Provide clear instructions on how new users can configure their privacy settings before using the macro tool. A short guide within the Excel file or a separate README document can help users set up the necessary settings.
Create a clear instruction guide for users on how to set their privacy settings appropriately when they first open the file. This can help ensure that they do not see undesired behaviors due to default privacy settings.
