How to handle errors without your report refresh failing, while also alerting on the fact that there are errors. This will handle errors such as:
Error messages like: DataFormat.Error: We couldn't convert to Number. (or date etc)
Also includes how to fix column name errors, which are very common in things like Excel or SharePoint sources.
We also talk about how to prevent errors in Excel files specifically in the video linked in the “related videos” section below!
⏲️ TIMESTAMPS
0:00 Intro
0:39 Basic troubleshooting
1:24 Querying error info
3:50 Preventing the refresh from failing on error
5:00 Fixing name reference errors
6:30 Alerting on errors
▶️ RELATED VIDEOS
- Tricks for using Power BI with Excel files (and preventing issues): https://youtu.be/io4c0lYMIgk
- Make a Power Query filter NOT case sensitive: https://youtu.be/vq1qtHTS7as
- How to schedule refresh on SharePoint sources in Power BI: https://youtu.be/ba1Akv63GDQ
🪽 CONNECT WITH ME
- Blog: https://christine-payton.com/
- LinkedIn: https://www.linkedin.com/in/christinehpayton/
🎁 SUPPORT THIS CHANNEL
- Shop: https://shop.bi-ome.com/
#excel #powerbi #errorhandling