The particular present submission will be perhaps more for that beginner in Energy BI, how in order to troubleshoot file alterations in Power DRONE. This especially makes reference to excel and even CSV file alterations.
These changes could be any of the following:
- The file was moved from its original location
- A column was added/removed
- Column name changed
1. File was moved
If you want to troubleshoot document changes, this is usually the most frequent problem, we all shift files around within our drives all the particular time, using Power BI Course, this is certainly clearly an issue, nevertheless a very easy order to fix.
All you have to do is direct your report to the file in the new location.
Go to the Transform Data option.
Navigate to the correct table.
Go to the source and browse to the new location, and that’s it.
2. A column was added/removed
Incorporating a column: This can cause problems, however, not always, when a new line was added a person should simply end up being in a position to refresh your own data, as well as the line, will be noticeable. BE CAREFUL, when you have completed some extreme strength query on the particular table, like unpivot/pivot (port) your data, this may distort in addition to mess this upward big time. Additional post on incorporating a custom line here.
Removing the column: Again when you have not necessarily performed any changes on this line or used this in an aesthetic, you may not necessarily experience problems, nevertheless say you might have. Within my example, Used to do just one modification (Capitalize Each Word) in the steering column.
I then went along to my excel piece and removed which column. Saved together with closed it together with went back to be able to my report together with a pressed refresh. My spouse and I get them down below error.
Go to Transform data
See the first step about your Applied ways panel, and operate your way lower until the problem occurs. In my personal example, it’s about the last phase, and I may simply delete which step. BE MINDFUL, if your phase is not typically the last one, most subsequent steps may well be influenced according to what you will be deleting, I advise saving the record before attempting this specific. Deleting a phase is permanent, undo-options are not offered.
3. Column name change
With my example I currently have a Countries steering column, I did quite a few transformations in my own table that correlates to that steering column. Then I went along to my excel piece and changed typically the column name to be able to Country.
Tried to be able to refresh the survey, you will enjoy the down below error again.
This time around the steps will certainly return a mistake. You will possess to replace the particular column name within the Advanced Editor area. For each stage and instance that will the old line name is referenced, you will possess to in purchase to the brand new. If your program code here is really long, you are able to duplicate and paste it into a notepad textual content file and good and replace this. BE CAUTIOUS the littlest change just like an interval or parenthesis will certainly break it plus is very hard to troubleshoot.
This particular will fix your own table, although not really always you're visible, you may have to replace the particular field forcing a person to have a good error with the particular newly renamed industry.
Remember that this answer is ideal whenever a column title has been transformed indefinitely. In a few instances, you may expect a line name to improve regularly, for those situations another approach must be taken, view this particular awesome article with regard to more information upon that.
I wish this helps a person “fix” your damaged report and possess it in come back to working within almost no time.