Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥
Best video on the subject on RUclips. I have watched so many before I got to this one and this instruction clearly makes you understand what Excel is doing and why the errors occur. Thank you.
You're most welcome! Please check out this video here for using dynamic column names: ruclips.net/video/Mh-39eXrBTg/видео.html and if you want to find out more ways in which to make your queries dynamic please check out this video here also: ruclips.net/video/MMF3bNXqT2c/видео.html
I received this error very often and am start cm with is expression error , The key did not Mach any rows in the table. Hope you are able to provide some guidance. Thank you
Hi T Lee, an example of when this error would happen is when you connect to an Excel file and then your query attempts to connect to a Sheet that does not exist in the Spreadsheet, when you’re working with data sources in Power Query if something in your data source is renamed or deleted then your query will break. You can fix this by changing the name of the sheet go to the Excel workbook and change the name of the sheet back to what it was in the query. Hope it helps. I will add this to my list of videos to make, please turn on your notifications so you know when that video is uploaded.
This usually occurs when the Changed Type step is performed, e.g. the column has numbers and text in it, like NA, but the column is a whole number data type. You could change your source data, so remove the NA or use the Replace value / error function to replace the NA in your query with a value.
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe
🚀🔥
I have to repeat what another user said: Best video on this subject on RUclips so far. Thank you.
What a great tip. Remove other columns.
Best video on the subject on RUclips. I have watched so many before I got to this one and this instruction clearly makes you understand what Excel is doing and why the errors occur. Thank you.
Thank you so much J G, really glad the video was helpful!
Great explanation! Thank you!
Thank you for this video. How please could these solutions be done using dynamic column names? Thank you 🙏🏽 .
You're most welcome! Please check out this video here for using dynamic column names: ruclips.net/video/Mh-39eXrBTg/видео.html and if you want to find out more ways in which to make your queries dynamic please check out this video here also: ruclips.net/video/MMF3bNXqT2c/видео.html
you told that the column names will be hard coded, even when the changed type step is at the last its hard coded right, why didnt the query break
I received this error very often and am start cm with is expression error , The key did not Mach any rows in the table. Hope you are able to provide some guidance. Thank you
Hi T Lee, an example of when this error would happen is when you connect to an Excel file and then your query attempts to connect to a Sheet that does not exist in the Spreadsheet, when you’re working with data sources in Power Query if something in your data source is renamed or deleted then your query will break. You can fix this by changing the name of the sheet go to the Excel workbook and change the name of the sheet back to what it was in the query. Hope it helps. I will add this to my list of videos to make, please turn on your notifications so you know when that video is uploaded.
Could you me please I can't fix my on power query
So useful.. Thanks a lot👍👍👍🤩
You’re most welcome 😊
your video is very helpful....thank you
You're most welcome and I'm glad it's helpful Rizky!
Thank you for this video
My pleasure Dins :)
Brilliant
Glad you like the video :)
How to fix the following error: [DataFormat.Error] We couldn't convert to number
This usually occurs when the Changed Type step is performed, e.g. the column has numbers and text in it, like NA, but the column is a whole number data type. You could change your source data, so remove the NA or use the Replace value / error function to replace the NA in your query with a value.
Manny manyy 👍👍👍👍👍 thanks
It’s a pleasure Santu :)
Amezing
Thank you 😊
Thanks you bebe