While this works like a champ, I am running into issues with the refresh being interrupted by a prompt to confirm authorization of a native query. In Power Query, I typically get a yellow "Edit Permissions" bar and click "Ok" to allow it to run, but it is periodically being reset.
Is there a way to modify the refresh to access that native query authorization or confirm allowance when the prompt appears?
While this works like a champ, I am running into issues with the refresh being interrupted by a prompt to confirm authorization of a native query. In Power Query, I typically get a yellow "Edit Permissions" bar and click "Ok" to allow it to run, but it is periodically being reset.
Is there a way to modify the refresh to access that native query authorization or confirm allowance when the prompt appears?