Collin Quiring on 04 Oct 2018 21:18:17
I would like to have the ability to do a "compare tables" or "compare queries" option.
I understand that there are visuals/queries I can build to compare the DATA within two separate queries but I want to compare the two queries. I want to know how many columns are in TableA versus how many are in TableB and which column names are different from each other. When I have two tables with 150 columns (give or take) and they are allegedly a copy of each other I want to be able to confirm that all 150 in columns in TableA match all 150 columns in TableB and that I don't have 10 unique columns in each query that just happen to come up to 150.
It would be nice to get a row count difference at the same time, but I do know that I can do the count rows to get that number of each.
- Comments (1)
RE: Compare two Queries - Columns
Check out my PowerBI tool to compare data it might fit your needs
https://github.com/stretcharm/PBIDataComparison
https://community.powerbi.com/t5/Data-Stories-Gallery/PowerBI-Data-Comparison-Tool/m-p/658314