locked
permission required - to query the external DB RRS feed

  • Question

  • Hi 

    1. What is the permission require to query the external DB to collect data

    2. power bi can update data in database ? 

        because I'm creating new column , change the format of the field (e.g date, from integer to text), , creating new index . 

      just to want to make sure i'll not the messing the production database . when playing and manipulating data in power bi. 

     


    Help.Me


    Saturday, March 7, 2020 4:42 PM

Answers

  • Unless you're running native queries (which are native SQL and thus can do anything SQL can do), all built-in PQ operations should be read-only.

    Ehren

    Monday, March 16, 2020 8:27 PM