Forum Discussion
Add an extra field from a data source
- Anonymous
If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
I have this issue also and it is very frustrating. We add addional columns and fields to source csvs all the time.
I have a work around that used to work...until today.
This way you will not lose any of your steps, which is very important especially if you have a complicated report that could break.
The work around is this:
1) refresh everything, make sure the new column is in the source csv
2) under applied steps in query editor, go to source and hit the settings gear icon to right of "source"
3) Choose Open file as "Automatic" hit OK
4) Your table will dissappear, double click the csv file icon, hit "insert" when the insert step box pops up
5) Your newly added column will appear at step 1 "source"
6) to make sure it stays , under "choose columns" or if you have a "removed columns" ...make sure the check box for that new column is checked
7) Your column is good to go now
This usually works. Except today it started giving me a wierd error after applying query edits Which is why I am here searching.
EDIT* I fixed my error. I was being dumb. My work around works again.
To add to this. I had a SQL data source. Going into "Edit Queries" and refreshing made the column appear in the preview. However after clicking "Close & Apply" and viewing the fields in the dataset in the right hand panel, the new column still wasn't appearing. I'm not sure if this had something to do with the fact that I had already added some calculated fields.
My solution was to go back into "Edit Queries" and simply move the column from the end to another position in the table. This created a "Reordered Columns" step. After closing and applying now, the new field appeared in the right hand panel. Hope this helps someone.
To add to this thread, I have a sql data source and was having the same issue. I could go into "Edit Query" and refresh the data and the new column would appear in the preview. However when I clicked "Close & Apply" the list of fields in the panel on the right hand side for that data set would not change. It was very frustrating. I didn't want to delete and add the data source because I had already created a bunch of calculated fields that I didn't want to have to do all over again. I'm not sure whether the existence of these extra fields was what was causing the problem.
I decided to try and change the data source in some way to see if that helped. I went back into "Edit Query" and moved the new column into another position. This created a "Reordered Column" step on the query. When I clickec "Close & Apply" this time, the new column appeared in the fields list on the right hand panel. So that was my work around.
