Can powerquery be set to readonly to the database? RRS feed

  • Question

  • I understand you can use SQL statement to update data or even drop table.

    Can it be set to read only access to the database?

    Friday, July 28, 2017 1:20 AM


  • Well you need credentials for the DB, so you can set read only there. That is the only way. I guess simply don't give Write access to anyone that doesn't know what they are doing.

    Self Service BI Expert using Power Pivot

    Friday, July 28, 2017 10:26 PM