Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error message: XX column cannot be found after change folder path

Dear community memebers,   Recently, I set up a file with the folder as the data source. The folder is located in a shared drive, where credential is needed. I would like help my colleague to set ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  Anonymous 

    Is it possible that it is related to the csv encoding format?

    Will there be garbled characters when accessing the csv file on his side?

     

    If you have no idea about that ,you may need to open a support ticket with MSFT to investigate this issue.

     

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Eason,

 

Thank you for your reply.

 

The M code and the files are totally the same. The source files and the pbix file are sent out from me after they ran sucessfuly from my side. And I compared and checked many times that my colleague uses the same things as I. (M code, columns, etc.)

 

Best regards,

ChiaoC

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  Anonymous 

Is it possible that it is related to the csv encoding format?

Will there be garbled characters when accessing the csv file on his side?

 

If you have no idea about that ,you may need to open a support ticket with MSFT to investigate this issue.

 

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Eason,

     

    Thank you! it is a good hint. Let me try again with my colleague next week regarding this point. If it still not works, then, I will follow your suggestion.

    Thank you again for your kind help!

     

    Best regards,

    ChiaoC

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Eason,

     

    Let me update the situation.

    While I was checking the encoding of my CSV file and the CSV file my colleague downloaded, I recognized that  seperator-delimited formats is different. Mine is comma and my colleague has semi-colon. So, I think it is the issue.

    Thank you again for your hint that helps me to discover the setting difference.

     

    Best regards,

    ChiaoC