Changing the data source problems

[Anonymous]

Changing the excel data source on Power BI, same columns and sheet name, I come up with the following error: "The column 'COL_NAME' of the table wasn't found."

The named column exists on both sheets, and I haven't modified nor renamed the 'COL_NAME' column in either sheets. Neither of my tables are empty either.

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Anonymous ,

Please check the Changed type step in power query:

The name in this query should be the same as your column name.

Look forward to your dummy data source sample.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[marceloVVR]

Friend this is an unusual mistake.

Did you follow the data transformations correctly?
Use the first line as a header

If the error persists, try to pass the names already correct in your spreadsheet to import.

[Anonymous]

Hi Marcelo,

It doesn't seem to be a header issue right now, but thanks for the lookout!

[parry2k]

@Anonymous can you post power query m code, click advanced editor and paste the code here to understand what is going on. We are really shooting the dark here, you should remove sensitive information or redact it and then share it. you have to do some work to get help, just cannot say I cannot share the information. How do you expect to get help?

[Anonymous]

@parry2kGood point, I'm not trying to make it hard for you, let me try to clean it up and share it when I've scrubbed it. Thanks for taking a look.

[parry2k]

@Anonymous is there space in the name? Can you share pbix file and excel workbook, remove sensitive information before sharing. There could be many reasons for this, have to take a look at what is causing this.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Hi Parry,

There's no space in the name of the column, and unfortunately the whole table has PII and other sensitive data in it, although I came to this error after following the initial error of:

“The key didn’t match any rows in the table”

Which I circumvented by removing the Navigation step in the edit power query window. However, now I'm running into this error after side-stepping the key mismatch earlier.