I have a problem with privacy levels in PowerQuery. If I'm using mit Queris in the office and update the queries everythink is working fine, if i'm going to use the Querys in homeoffice via vpn i have to set the privacy levels again. Doing so in homeoffice everything is working fine again. Back in office I have to set privacy levels again.
Sometimes I'm getting a notice message to set privacy levels again and can choose if it is okay. Sometimes PowerQuery just updates the queries without a notice message. It seems that the query is updated, but in truth nothing is happend. I just can see a warning triangle if I'm going to fade in the connections on the right side.
Is there a possibility that everytime I get a notice message for setting privacy levels?
To circumvent this issue I also thougt about using two different queries. On in company and one in homeoffice with vpn, so that I always have the same privacy leves and the same network. Do you think this will work?