Forum Discussion

ronny_wdk's avatar
ronny_wdk
Frequent Visitor
6 years ago
Solved

extra column in data source

I use a folder as data source. In the folder are multiple .csv files (a file a day).

 

I recently added a column to the source, so the old files have 50 columns, the new files have 51 columns.

 

When I refresh the data, the extra column is not available in PowerBI.

How do I solve this?

 

Thanks a lot.

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi ronny_wdk ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

10 Replies

  • butlerjay87's avatar
    butlerjay87
    Helper I
    6 years ago

    Have you refreshed the 'preview' in Query Editor?

    Please accept solution if this works for you.

    Thanks

    • ronny_wdk's avatar
      ronny_wdk
      Frequent Visitor
      6 years ago

      I refreshed the preview, but the extra column is still not visible.

       

      (additional: the extra column is only in the new files, not in the old files).

       

      Ronny

      • butlerjay87's avatar
        butlerjay87
        Helper I
        6 years ago

        Are you able to share the .PBIX file?

        I'll be happy to have a look at it for you

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi ronny_wdk 

     

    You can add the Column name manually in the step where you expand the columns.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi ronny_wdk ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

    • ronny_wdk's avatar
      ronny_wdk
      Frequent Visitor
      6 years ago

      Thanks a lot, it worked!

       

      I removed my address.

       

      Ronny