Forum Discussion
Helper IPower Bi does not detect newly added columns to connected csv
Hi koshur. I created a csv with 3 columns, brought it into Power BI Desktop, added some columns in the Query Editor, and then added a column and measure with DAX. I went back to the source csv and added a new column, and when I refreshed I had the same issue - no new columns. But...
If you go to the Query Editor and click on the Source Applied Step, you should see something like this:
= Csv.Document(File.Contents("\\folder\subfolder\filename.csv"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None])The part that says Columns=3 is important. That's how many columns are being delimited, which will also limit how many columns can be brought in. In my example I had 3 columns, and then added 1. Once I changed the number to Columns=4, the new column came in, and worked with all of my other steps, DAX, etc. Change it to however many columns you're expecting to bring in now and you should be good!
Resolver IHi koshur,
First within the .csv file if the data is within a table, make sure the newly added columns are apart of that same table.
If the format of the .csv file is clearly correct. You may need to change what columns are being pulled into Power BI via Power Query (the query editor).
To do this:
Under the Home Tab<Click Edit Queries< (This will take you to the query editor) on your right hand side there is "applied steps".
The first step is "Source" at this level you should see the option to import all columns.
You can also try within Query editor to click the "Choose Columns" and see if your new columns are showing up for import.
Lastly you can click "Advanded editor" and try to add that column's there or the number of columns in M. The syntax should be repeatable as seen in the M code which has been applied to the other columns.
Let me know if any of these work for you.
Christian
Helper IThanks Christian!! Columns=9 did the trick from me. I'm excited to see how active the forum is.. :smileyhappy: