Forum Discussion
Power BI - updated colums automatically
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!
Responsive ResidentHi 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!
I have to add in Column by Index and rename that column. Thanks.