Forum Discussion

AP_BI's avatar
AP_BI
Frequent Visitor
6 years ago
Solved

Power Query does not recognize subsequently added columns in source file

Dear community,   I get my report from a connected .xlsm from a sharepoint. I had to add 3 columns to the basic data of the .xlsm file. Unfortunately the columns are apparently not recognized in Po...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.

Fowmy's avatar
Fowmy
Super User
6 years ago

AP_BI 

Can you open the file directly from SharePoint and check if you can see those newly added columns?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS šŸ™‚

YouTube, LinkedIn

  • AP_BI's avatar
    AP_BI
    Frequent Visitor
    6 years ago

    Hello Fowmy 

    yes, that works perfectly fine. I tried it with Sharepoint Folder as well as Excel offline source and there is no problem with the added columns. 

    Probably I have to change some of the applied steps (refer to the picture). As you can see the Sharepoint has lots of different files. I filtered for .xlsm as it is the only file I want to use. After that I removed top rows. But the last 3 columns from source data are missing.

     

    • edhans's avatar
      edhans
      Community Champion
      6 years ago

      Your "Removed Other Columns" step will always remove newly added columns. You either need to edit that step, or remove it and instead select the columns you do not want and remove those. Then newly added columns will always come in.