How to fix error getting data from Folder

[bluetronics]

Hi,

Marketing team releases data monthly basis. I save it and analyze it by Power bi. I tried to get Data, but it doesn’t work properly. Is there anyone can support me how to fix the problems?

1. How I did work:

   - Get Data from Folder and Combine Files

  - Remove rows

2. Problem #1

  - Error happens when I try to use first row as headers. How I can fix it?

3. Problem #2

  - The Data to be used as headers isn't the same when marketing data is issuing different years like 2019 Dec and 2020 Jan.

  - The differences happen only form BA column to EO Column

  - How to handle this when I am loading data?

Regards,

[v-diye-msft · Accepted solution]

Hi @bluetronics 

The error message in Power BI really sometimes not very helpful in pointing out the source of the problem.

Here're similar posts could probably be your reference:

https://community.powerbi.com/t5/Power-Query/Expression-Error-The-Column-Column-X-of-the-Table-wasn-... 

https://community.powerbi.com/t5/Desktop/The-column-lt-ColumnTitle-gt-of-the-table-wasn-t-found/m-p/... 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-of-the-table-wasn-t-found/td-p/... 

[bluetronics]

Thanks a lot! It's not easy to work. 🙂 I will try to find the way after reading on linked Posts.

[Greg_Deckler]

Looks like you have a Renamed colums step in there so maybe you renamed Column1? 

On the other one, generally you select the columns you do not want to unpivot and then choose Unpivot other columns.

[bluetronics]

I didn't Rename Column 1 that is created automatically when I get the data from folder.