Forum Discussion
Will the changes make on import data affect the data sources in SQL servers?
- Anonymous7 years ago
Power BI only uses Read-Only access. Your data changes only affect the Power BI model you are working on.
Dear all
A quick question:
if I choose "import" instead of "directly query" and made some adjustments on data, such as delete some rows/columns, edit few cells, or even delete the whole table, I assume those activities only happen in my personal computer and will not affect anything in the SQL server.
And when I clicked "refresh", the new data will be added into the data in my personal computer based on the existing queries I made.
For example,
I imported the below chart from SQL server
Then I removed the duplicate ROW and group those countries into groups, like put USA and CANADA into NA bucket and the rest countries into ASIA by adding a new column.
Now, the table on my Power BI looks like
After few minutes, a new member joined, No.9,
After I clicked "refresh", the table on my personal computer will become
However, on my company's SQL server, the table will look like the table below:
Kate is added but other columns and rows will not change.
Thank you for answering this basic question in advance.