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.   ...
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,

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

    • ronny_wdk's avatar
      ronny_wdk
      Frequent Visitor
      6 years ago

      the file is 67 MB and contains private data.

       

      I can send you in pm?

       

      Ronny

       

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

        Hi ronny_wdk ,

         

        First of all, we suggest you to delete your email address and do not share your file if it contain any confidential information or real data.

         

        If your csv files are comine by the gui, we can use the following steps to expand the new column:

         

         

         

        1. Change the Sample File name to the new one

         

         

         

        2. change the column number of "Transform sample File" query

         

         

         

        3. Refresh all queries

         


        Best regards,