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!
Memorable MemberHi 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!
koshurthanks! this worked. Although something is not right with the calculations. the % calulations seem off. I've pinged the freelancer.
I just wanted to thank you, I was lloking for this and was getting very complicated instructions from other posts but yours is simple and worked perfectly
- RevOps608
Helper II
Thank you! It worked for me also.
