Find All Errors in All Columns using Power Query in Power BI

preview_player
Показать описание
Errors often happen when loading data into any BI system. In this video, the 2nd video after my previous one in the series, I am explaining how to catch the error rows and columns, even in a situation where you don't know which column might cause the error. You will learn how to use Power Query inside Power BI to capture the error details and build an exception reporting in Power BI.
Рекомендации по теме
Комментарии
Автор

OMG so much gold in one small video - thanks Reza! Never did I click on that table icon to get all columns functions plus I did not know about 'Try' function. Great use of unpivot too :)

GandalfGuy
Автор

Great way to land on the errors and do something with them. Thank you Reza and much appreciate you putting this video together.

christianlira
Автор

Extremely useful and well demonstrated tutorial. By far the best one I have seen so far on error handling 👌🙏👌

alexrosen
Автор

Thanks Reza, This is a brilliant solution for maintaining clean data without errors while simultaneously having a table that shows which column has errors and what the errors are. Additionally, I think it would be beneficial to unpivot all columns by selecting them all, right-clicking, and choosing 'Unpivot Columns, ' since even a key column might have errors.

Softwaretrain
Автор

Brilliant movie. I spent a lot of time locating bugs. Now it will be easy. Thank you.

cezaryczajka
Автор

Thank you soo much Reza! You are a Power Bi wizard. Can't wait to learn more :)

LIV-FREE-VET
Автор

Amazing thanks Reza, you've just conquered the dreaded PQ error message. I was aware of all of those PQ features, but didn't think to use them in that way.

timosborn
Автор

This is great information. Thanks for sharing!!

MuratBarbarosYamak
Автор

Absolutely amazing, thank you Reza for so many useful information in 11mins video. Thank you for sharing

sabarashid
Автор

Hi Reza - I am working with MS Exchange data which I'm using Parameter date to refresh it the data in PBI server only, because it requires a refresh after each PQ step in PBI desktop.
In the desktop model I work with 1 month - no errors.
But I get null value can't convert to logical value type error in PBI server
I am doing a few Group By which I'm pretty sure is causing issues. But so even trying to detect my error using your tips doesn't work.
When it takes 1 hour for the refresh it's very time consuming.
If you have any tips for working with MS Exchange data that would be interesting. Thanks 🙏🏽

Bondoz
Автор

Re: import mode file size
What is the maximum file size in MB that I should start looking at SQL server or direct query? Thanks

txreal
Автор

Hey Raza, all good man. You look a little under

osamaasif