Forum Discussion
Add an extra field from a data source
A power bi newbie here.
Say if I import a table A from a data source into power bi, some minor changes to the imported dataset. calculated columns, measures etc.
Now I add a new field in the table A, how do I include the new field into the data set in power bi (without re-creating a new one)?
Thanks in advance.
- Anonymous
If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.
47 Replies
- Anonymous
If I didn't misunderstood you, when you refresh in power bi desktop your new added column will automatically be imported.Hi,
I expected the functionality to work as you explained, but it doesn't for me.
I am using a local file. It is an Excel spreadsheet with a table. The table has 4 columns. If I add a fifth column with data, I would expect the field to show up in Power BI after a refresh. I click refresh for the datasource and it refreshes successfully. Then, I go to report and the new field does not show up. The only way to get the new field is to delete the old datasource and add a new one.
Thoughts?
I have the same problem: If I add a column to my original data source in Excel and refresh in Power BI, my new column doesn't show up. Is it possible to get the new column or is the only way to start from scratch? (I'd rather not since I've build relationships to other sources, added calculated columns, etc.)
Hi bon_lenard,
Can you please add a print screen of the PB editor, so we could se the situation?
Grtz
Can someone please post some screenshots or a link to guide me (and anyone in my situation) on how to get additional columns/fields from a .CSV spreadsheet to Power BI without affecting my existing data model and reports? I'm stuck with the same issue and did not find your steps actionable in my PBIX. I'm on Version: 2.75.5649.861 64-bit (November 2019).
Thanks in advance.
Kind regards, B
Think I found why this wasn't working for my updated CSV file. In the Advanced Editor window the first line of code list how many columns the query is reading on the source. I had to increase that number to the new total columns in the csv in addition to adding the column names to the query. Afterwards, a simple refresh did the trick.
I also have the same problem as the topic starter.
Both the proposed solutions work for me, changing the column amount in the advanced editor and switching the source to automatic.
But is there a possibility to make the number of the amount of columns in the advanced editor a variable?
So before the data is imported, the columns are counted in the source, stored as a variable and then with the import source step the variable is put after the columns
Ex. [Delimiter=";", Columns=X, Encoding=1252, Quotestyle=Quotestyle.None]),
Where X is the counted variable.
Maybe this could automate the 2 solutions, if it is possible
Hi,
I know this post is marked as Solved, I just want to add my experiance on this issue.
When you add a column to the data source file, on Power BI or Power Query into 'Query Editor' you should Refresh All but after that nothing will change because your column selection refers to the first source file you loaded and is being used as 'Sample File'.
A new 'Sample File' will be created under 'Transform File from Data' (on the left Queries [#] column).
To solve this issue just choose the right 'Sample File' in the 'Manage Parameters' menu
Hello Community
Does this video (https://youtu.be/YCCMCIktTdQ) by Ruth still stand good as of today to bring in added or deleted columns from Excel Data Source to Power BI without any issues or is there an updated feature or functionality from Microsoft Power BI?
Please let me know because I am in this situation too with business adding and deleting columns in the Excel Data Source.
Hoping to hear from you soon.
Kind regards, B
Anonymous wrote:Hello Community
Does this video (https://youtu.be/YCCMCIktTdQ) by Ruth still stand good as of today to bring in added or deleted columns from Excel Data Source to Power BI without any issues or is there an updated feature or functionality from Microsoft Power BI?
Please let me know because I am in this situation too with business adding and deleting columns in the Excel Data Source.
Hoping to hear from you soon.
Kind regards, B
Hi All
i also have the same problem.
paul
Thanks for metioning the video, it helped me to get around the newly added column to the dataset (multiple files on the Sharepoint folder combined)
I know this was solved but found an even simpler solution.
In power query select the query in question > right click > select advanced editor
On line 1, where it lists your file source, change column = x to column = x + y
where x = the default column number listed
where y = the number of additional columns missing (OP situation would change it from 4 to 5 if the original file had 4 columns and 1 added column so should list as column = 4 to column = 5)
Make sure you have saved your spreadsheet before refreshing in Power BI.
Refreshing columns that are already there is no problem. Getting the new columns included is though.
I had the same issue. My source is a URL that returns a CSV. When the owner of the URL (a vendor) adds a new column to the CSV, PowerBI does NOT detect the new column.
I have gone into Edit queries -> Refresh Preview.
I can copy / paste the URL from the "Source" of the query into a browser and the CSV that returns has the new column.
However, looking in PowerBI...even clicking on the "Source" in the "Applied Steps" so that NOTHING has been done with the source data - no columns hidden, etc - the new column is NOT there.
If I change the URL to nonsense, save, then re-paste the URL into the source it will then find the new columns. A clumsy forced refresh. Should be a better way.
I have data in a flat azure table with 80 columns. When I getting this data to power bi it analyze only 1000 first rows and automatically creates fields. The problem is that first 1000 columns contain just 25 collumns and bi automaticaly creates not full structure. How I can manualy set data scheme and specify all fields manually?
Thx!
Hi All,
I have the same issue while I want to extract column from SSAS Analysis Cube.
What I did:
I connected SSAS Cube by Get Data..Then I select some specific fields based on my requirement from one of the package(A package consisit many fields).
Now, How can I add one extra field from the package???
Thanks,
