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.
4 Comments
- 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
Update 8/15/2024: Moved from Power BI ideas to Data Factory ideas.
- Status added:Needs Votes
- miguel
Community Admin
Status changed:Needs VotestoNeed ClarificationJust trying to get more clarity on what the ask is or what sort of scenario y ou envision for this, would you say that this is more about comparing the schemas rather than the data of both tables?
Today you can use functions such as Table.Schema to get the schema of both tables and compare the two schemas.
What sort of comparisons or outcome would you like to see? do you have any examples of what would help you the most in terms of structure of the response in the event that there was a simple function that could take a list of table queries?
