© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
J. M. RhodesCreating Business Applications with Microsoft 365https://doi.org/10.1007/978-1-4842-8823-8_18

18. Using Power BI to Find Inconsistent Data Between Excel Spreadsheets

Jeffrey M. Rhodes1  
(1)
Colorado Springs, CO, USA
 

This example solves a challenge that confronted my wife, Sue, in her job in human resources. She had to reconcile large spreadsheets taken from different systems that had conflicting data. Since these had hundreds of rows and dozens of columns, trying to eyeball the differences was time-consuming and prone to errors. Since she has to listen to me drone on about how great Power BI and the rest of the Power Platform is An image of the ...

Get Creating Business Applications with Microsoft 365: Techniques in Power Apps, Power BI, SharePoint, and Power Automate now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.