Can I protect my Power Query Tabular? RRS feed

  • Question

  • Hey is there any possibility to protect my Power Query, so that everybody can see in Excel whats in the Tabular but nobody can do edit, just if that person has my Password? Because when I protect the Excel sheet normally, the Ledgetable doesn't load up the information from the Power Query

    I hope everybody understands what i want :)

    Friday, January 15, 2016 7:44 AM


  • You can do that by protecting the workbook structure only (Arbeitsmappenstruktur) instead of the whole workbook.

    But please keep in mind that this is not a secure protection method: As users need access to the underlying data if they should be able to refresh the data, they could easily copy the code (via sending a frown) and create the same query in a different workbook with that code and modify it there.

    However, if it's just about protecting people from doing stupid things and messing up their reports this method should work just fine.

    Imke Feldmann TheBIccountant.com

    Friday, January 15, 2016 10:10 AM