none
Clear Permission for Excel Power Query Data Connection via VBA RRS feed

  • Question

  • Hi, 



    I was wondering if anyone can help with clearing permissions (authentication) for a workbook query data connection set. I understand there is a manual way of removing it as described in link <https://www.c-sharpcorner.com/article/edit-or-remove-permission-from-existing-data-source-connection-from-power-bi/>



    However, I would like to know how you can code it in VBA. 

    I see the following info in the documentation; however, it does not remove or clear the permission/ authentitcation (Basic) when invoking the call.



    https://docs.microsoft.com/en-us/office/vba/api/office.permission.removeall



    Any advice is greatly appreciated.



    Thanks!
    Monday, November 19, 2018 11:32 PM

All replies

  • Hi,

    I'm currently experiencing the same issue. Since the file is for other users, the "manual" way is not possible.

    Have you or anybody else been able to solve the issue via VBA?

    Thank you very much in advance.

    Kind regards

    Nils

    Wednesday, January 23, 2019 3:26 PM