Home Power BI How to add extra columns to an existing Power BI file which has CSV as data source

How to add extra columns to an existing Power BI file which has CSV as data source

by Prathy Kamasani August 4, 2016 0 comment

Quick Power BI Tip:

Case: How to add extra / new columns to an existing Power BI file which has CSV as data source?

Solution:

When I was working with Power BI today, first I created a model with my CSV files, while I was doing the report; that is when I realised I need one more column from the data source. After I had received the new file, I thought I would just refresh the data source and power BI automatically refreshes my query. In fact, Power BI does automatically update my query but what I noticed was, it excluded the last column. When I looked in the advanced editor query looked like my example here

2016-08-04_06-08-57

I can see, it is strictly bringing two columns only. So the tip is to simply get all the columns into the existing Power BI file, just change the number of columns to the new number of columns in the CSV file, which is 3 in my case.

Updated Query:

2016-08-04_06-21-21

2016-08-04_06-21-49

That’s all for now 🙂

Prathy

0 comment

You may also like

%d bloggers like this:
Skip to toolbar