Error Reporting in Power BI ⚠️ (Don't miss watching this!)
Вставка
- Опубліковано 5 сер 2024
- Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
In this video, I'll share a creative use of Power Query to dig out the errors that often crop in your tables while loading or refreshing your models in Power BI.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Reza and Reid's Video - • Intelligent Error Hand...
Try and Otherwise in Power Query - • IFERROR in Power Query...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:56 Building an Error Check
6:32 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!
- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall UA-cam Channel Below
ua-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука та технологія
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
Really helpful, particularly for large data models or tables.
Thank you so much for sharing your experiences and knowledge. Appreciate
Your content is always top notch and this one is definitely going to be one of my favourites.
Great Video!
Great! Thanks!!
Hi Chandeep, I love enjoying watching your videos and these videos are helping me directly with my current job. Although while loading a table from a ODBC connection it gives me this error.
"Preview.Error: The type of the current preview value is too complex to display."
This is not letting me go any further, I went online to many blogs finding a solution, but did not help.
I request Chandeep and all powerBI enthusiast to help me get this resolved.
This is awesome 👌
This has happened to me too many times 😁 so I am very grateful for this tip!
Glad it helped!
Super useful stuff
Hi Chandeep, this video helped me to find the data format #Name conversion error, appreciated your efforts making these video's thanks
Thanks 😊
Amazing power query videos. ❤️ Thankyou for sharing knowledge
Glad you like them!
Good one
Nice! I subcribed and shared this on LinkedIn too!
Thanks Tom!
fabulous
Thanks!
Thank you so much 🤩
Recently i Face this problem. Thank you for this video. Kindly make a video on Unable to save document( Unable to read beyond the end of the stream.) error.
Have you done a video yet of when you load data (from an Excel sheet on SharePoint, for example) to PBI and get an error, only for a few rows, where the data shifted over a column? For example, if you had a Customer table with columns Customer ID, First Name, Last Name, Email, but in 3 rows, you see that PBI has shift the Customer ID to the First Name column, the First Name to the Last Name column, etc. And when you look at the source file, those rows look fine. Can you help me resolve that issue, please??
Good video but this can also lead to data loss at some point right? Imagining having Date column with like 202(2)-01-15 where someone accidentally missed number in brackets for year...or it can also be in month part or so on...I am telling this because I had such issues, where you need to replace values to avoid any loss....but just using this on this way might be dangerous.
hello what is exactly a DataFormat.Error file contains corrupted data ? thank you
Hi Chandeep, I wanted to know can we connect jira with power bi using rest API without any plug-ins.. If yes could please me guide how can it be achieved...
How can join
I have a question, maybe you are able to help. I have one colum with numbers (like sales) and a column with criterium (like shop is in USA or not). I have to build percentage YTD for it (sales is 100 and 20 so 20% of it is in USA this moth, another month it is maybe 30 %. I have to build this percentage YTD for a criterium. Do you have any idea? I tried everything I found but it doesn't give me the right numbers.
try posting on the Power BI Community site - community.powerbi.com/
The nice and easiest way to track the errors.
I think we should go to the power query each time to see the error once we found one in the time of refreshing the powerbi model. Cause, the powerbi will never load the errors. Am I right?
You are right!
Hi chandeep I have this problem in my date column I will get some blanks but my power query mark them as errors how to overcome that issue. Can you please help me?
Null values when converted to dates do not cause any problems! There could be something else.
I used excel file which contains a Filter formula that sometimes contained an error. The Filter error output in excel was #CALC. When loaded into Power BI, the error message was #VALUE!. I could not find ANY solution to remove this error or replace the error (including this video). Even when trying the “keep errors”, it gives me an error and doesn’t allow me to complete the step! Haha
Can you give me a solution for my uncleared(yet) question?
How we can connect to an API which has an auth token?
That is,
Some APIs work like this,
1. Request a token with certain headers.
2. Accept the token and use the token as a header in each API call.
3. The token may be valid up to a specified interval. After that, we have to generate a new one again.
Is there any way to do this in PowerQuery?
Not sure. I'll have to research on this!