Forum Discussion
How to keep Dashboard & Graphs using new type of Excel Dataset
Hey euthor,
1. Depends what you mean by "while". If you are working on an excel file, doing some changes, and you haven't save it, then Power BI will not catch the on going changes, but you are no locking the file by working on it.
2. It may work seamlessly or break you report... most likely break you report :)
If you delete a column and replace by a new one, but has the same name, it is likely not to break you report
If you add a brand new column, Power BI will probably pick up the new column and nothing will change for your report
If you have new column name then I bet your load will break, you will have to adjust the edit query part. and if the column was supposed to be used in your chart, you will have to update that too.
All in all, your visuals will STILL be there, but they are going to return an error until you have updated the load/fields.
Resolver IIIHey euthor,
1. Depends what you mean by "while". If you are working on an excel file, doing some changes, and you haven't save it, then Power BI will not catch the on going changes, but you are no locking the file by working on it.
2. It may work seamlessly or break you report... most likely break you report :)
If you delete a column and replace by a new one, but has the same name, it is likely not to break you report
If you add a brand new column, Power BI will probably pick up the new column and nothing will change for your report
If you have new column name then I bet your load will break, you will have to adjust the edit query part. and if the column was supposed to be used in your chart, you will have to update that too.
All in all, your visuals will STILL be there, but they are going to return an error until you have updated the load/fields.
Hi Arentir,
I think I expressed myself in a very bad way so I am editing my first message! Thank you!