Solving DATE CONVERSION ERROR in Power BI / Power Query | Comprehensive Guide
Вставка
- Опубліковано 24 лип 2024
- In this video, we will learn how to resolve date conversion errors which occur during your data transformation step in Power BI / Power Query. This video will cover 2 primary scenarios
1. Date Formatting Issue
2. Data Entry Issue
To solve both of these scenarios we will see how to use a variety of functions, i.e.
Date.FromText
Text.Start
Text.Middle
Text.End
Try Otherwise
This is going to be a jam packed content, so don't forget to subscribe & hit that like button!
Data Used:
www.pivotalstats.com/post/fix...
Visit my blog for more content :
www.pivotalstats.com/
Affiliate Links --
Best Web Hosting Service :
bluehost.sjv.io/k0OkNv
Cool tech that I use for these videos :
1. Blue Yeti Microphone - amzn.to/43FEYdT
2. LG Ultrawide Curved Monitor - amzn.to/3rEMsR7
power bi,power bi desktop,power bi tutorial,power bi for beginners,power bi tutorial for beginners,power query,manage errors in power query,power bi training,powerbi,power bi date format error,power bi date format,power query date errors,date functions in power query,how to power bi,power bi date error,fix errors when importing dates power bi,date error in power query,power bi tutorials,power bi error,power bi date format change
Excellent, you are sharing gold..thank you so much.
Glad it was helpful. Thanks for watching!
Nice explanation, the catch is while writing a formula in PQ/PBI never use dot in it. simply write the textend it will auto suggest
👍
Hi there! Thank you for your video, was really well explained.
Glad you enjoyed it! Thanks for watching :)
please make videos from the various challenges like Maven, Onyx etc. so that we can start building dashboards on our own from that POV. 🎊
Thanks for a great idea! I have not looked into those challenges till now, but I will definitely plan something for future. Thanks!
while working on large volume data - if we resolve date errors - how we can check if there is still no undesired outcome
One simple way that I can think is to create a duplicate of ur final table in power query which will serve as testing table. In this let's say u want to check the date column, then you can remove all other columns and apply remove duplicate. This will give u a small list of items. Then its easier to check if everything is good to go or not. Hope this helps!
@@pivotalstats thanks indeed for your suggestion.
I have taken some subset of data in Excel to check but yes doing within powerbi should be a better option.
Why you are not make the video daily i check your channel plz upload the vedio we are waiting
I recently moved to a new country, so I'm still settling down. I will try to be more consistent in coming months. Thanks so much for watching!
all of this doesn't work I don't know why !
Hi, Are you getting any error?
To fix this issue I just jump to power BI desk top and on data view section select the Archive_date column and click column tools at the top and under data type select date data type from the drop down & select the format too...🍰🥧🧁. your approach didn't work for me.
Great, thanks for sharing. The techniques shown in the video will have to be used only if the simple approach of changing data type does not work. Cheers!