Forum Discussion

Account123's avatar
Account123
Frequent Visitor
9 years ago
Solved

Does deleting fields in the data model view affect the original data source?

I'm using directquery mode, from my understanding PowerBI isnt going to send a drop command to the DB but simply removes that field from the select query, is that correct?
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Account123

     

    That is correct.  Power BI can't update, or delete your source data, so when you remove a column in the Query Editor or in Power BI it's just for Power BI. :)

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Account123,

 

Phil_Seamark is right. As the question is answered, could you accept Phil_Seamark's reply as solution to close this thread? :smileyhappy:

 

Regards