Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For eg.I have below SQL query which needs to be run 2 times . First time in a test environment and the second time in the Production environment with different credentials.
Select name,location from EMP where empid in(101,102)
After running the query in Test and Prod Oracle environment.
1.I want to compare the query result from both environments. How many records match/mismatch
2.Empid in Where condition of SQL query should be parametrized. means empid in where conditions should not be hardcoded.At run time I can put any empid.
Is there a way in Power bi by which I can setup/save this configuration and just by one click I can run this?
@Anonymous
Solved! Go to Solution.
Not exactly sure what you mean "run this by just one click"
However...
If you import both sets of data, you can compare them using measures:
Common records = COUNTROWS(INTERSECT(Table 1, Table 2))
differing records table 1 = COUNTROWS(EXCEPT(Table 1, Table 2))
differing records table 2 = COUNTROWS(EXCEPT(Table 2, Table 1))
Proud to be a Super User!
Paul on Linkedin.
Thank You
Not exactly sure what you mean "run this by just one click"
However...
If you import both sets of data, you can compare them using measures:
Common records = COUNTROWS(INTERSECT(Table 1, Table 2))
differing records table 1 = COUNTROWS(EXCEPT(Table 1, Table 2))
differing records table 2 = COUNTROWS(EXCEPT(Table 2, Table 1))
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |