What to do and why Power Query won't detect data types correctly!

Have you been in the situation where you have a column with dates/numbers... but Power Query wont change the data type correctly? Lets explore why and how to fix it!
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@jaymehta3320]

Thanks for sharing this. Good example. I have actually, in all these years, never used Columns from Examples, but this is a good case.

[@CurbalEN]

Sometimes it works!!

[@hangfire6368]

Nice tip. I ran into that issue two weeks ago. Fortunately I was able to have the data view changed.

[@CurbalEN]

That is the best option for sure!

[@abhijeetghosh27]

Cool trick 👌 Thanks @Ruth 😊❤

[@sarajvo2010]

Nice

[@Phoenixspin]

I heard that Microsoft will be forcing people to Fabric and basically dropping Power BI. Say it ain't so.

[@CurbalEN]

AI might do what we do in Power BI in a few years , so if anything is going to kill Power BI my bet is on AI not Fabric.

[@juanm555]

Fortunately the 8.4k usd per month they are asking for a capacity that can do copilot stuff still seems a little bit too high... When they start lowering that f64 to say, f4 we'll start seeing real change

[@thienanhnguyenbui]

Nope. I use Fabric, and it includes Power BI already.