Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 w...
Need Help
Show and Tell
  • dhruvinushah's avatar
    dhruvinushah
    4 years ago

    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!

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

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.