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. 



    Saturday, March 7, 2020 4:42 PM


  • 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.


    Monday, March 16, 2020 8:27 PM