Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power BI - updated colums automatically

say I have Get Data from CSV, and loaded into the Power BI.

say next time, I need to add in a few more columns, do I need to remove that table and redo everything again?

Can I if Refresh data, it will add in those new columns, without me remove that table loaded previously?

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

There are several ways you can add columns to your already loaded query. 

Via Power Query using 'M'  -  you can use the Custom Column and build your custom column.

Via Power BI Desktop using DAX - you can create a calculated column. 

 

Based on your requirement and level of familiarity with either languages you can add columns accordingly. DAX is generally more familiar to excel users, while M is more familiar with C # users. 

 

Hope this helps, please give thumbs up and Mark my answers as solution for your question. Thanks!









View solution in original post

5 REPLIES 5
danextian
Super User
Super User

Hi @Anonymous ,

Csv.Document has the following syntax

Csv.Document(source as any, optional columns as any, optional delimiter as any, optional extraValues as nullable number, optional encoding as nullable number)

As indicated in the syntax, optional columns is optional so the M-Script below can be written without the Column parameter.
= Csv.Document(File.Contents("complete path"),[Delimiter=",", Columns=5, Encoding=65001, QuoteStyle=QuoteStyle.None])

= Csv.Document(File.Contents("complete path"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])

I did several tests and the data previews looked fine without the Column parameter.






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.
dhruvinushah
Responsive Resident
Responsive Resident

Hi @Anonymous , 
I have faced this before. It is important to understand that Power BI has different methods in which it internally gets data from different sources like csv, SQL Server, DBs etc. 
For the csv, if you have new columns created AFTER you completed the first load into Power BI, your refreshing of the query or the dataset will NOT reflect those new columns. 
Why? beause in the first / initial load of the csv files, the connection will be written to include a 'Column' count. You can check this in the Advanced Editor. You can change that value to new count of columns you have in your csv to get in the new columns of your csv data file. 

Run Refresh after changing the advanced editor query and you will be able to 'refresh' your csv power bi table with the newly added columns. 

 

Hope this helps, please give thumbs up if it did. Thanks!









Anonymous
Not applicable

I have to add in Column by Index and rename that column. Thanks.

Anonymous
Not applicable

I know there is Add Column in Power Query Editor, but what if I want to add in new column which is just another new column that is not related to another other columns?

Hi @Anonymous ,

 

There are several ways you can add columns to your already loaded query. 

Via Power Query using 'M'  -  you can use the Custom Column and build your custom column.

Via Power BI Desktop using DAX - you can create a calculated column. 

 

Based on your requirement and level of familiarity with either languages you can add columns accordingly. DAX is generally more familiar to excel users, while M is more familiar with C # users. 

 

Hope this helps, please give thumbs up and Mark my answers as solution for your question. Thanks!









Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.