Excel Data Refresh

I have a shared Excel file stored on our Sharepoint site. I run a powershell script each morning that opens and refreshes a power query to update inventory. 

If a user opens the Excel workbook locally (in app) they are prompted with a Privacy Settings Message. This in turn breaks/stops my automated script from opening and refreshing the queries each day as I get prompted to update the Privacy Settings on my end. 

This is my issue...https://answers.microsoft.com/en-us/msoffice/forum/all/privacy-levels-not-saving-for-file-but-per-user-in/b6723091-1ac6-40c3-977f-e2c8558e243f 

What are my options or workarounds here? Thank in advance.