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

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,

     

    • leigh_yh's avatar
      leigh_yh
      Frequent Visitor
      6 years ago

      Please help - I am having the same issue. I followed the steps you suggested and my new columns appear but several of the rows do not load correctly. It appears that data from several columns is being combined and shifted  into the first column. For example, the  Project Status column should all contain "Active".

       

      Thanks in advance!

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

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

        Hi leigh_yh ,

         

        It looks like the Line 22 and 24 does not convert into tables correctly, could you please verify if these rows have correct format in the data source? Could you please describe the approximate action steps?


        Best regards,