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.
Greetings!
I work in an organization with hundreds of departments, and each department has about a dozen reports. The reports are all the same -- meaning, every department has an 'employee birthdays' report, and every department has a 'budget status' report, and every department has a list of their employees, etc.
In other words, despite the fact that we have thousands of separate reports, they're all using the same queries, just with a different department location code. So, as an example, it'd be a query like:
SELECT * FROM emp_info WHERE location=8
SELECT * FROM emp_info WHERE location=9
SELECT * FROM emp_info WHERE location=10
SELECT * FROM emp_info WHERE location=11
SELECT * FROM emp_info WHERE location=12
...
The only thing that's changing is the location. It seems ridiculous to manually create hundreds of variations on the same SQL query, or to go pull in ALL departments (SELECT * FROM emp_info) and then manually filter them to create hundreds of variations.
Is there an easier way to create reports for each separate location automatically based on one query?
Thanks in advance!
Solved! Go to Solution.
Yes. It sounds like one report would do what you need.
That is about it. See this article for more info.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes. It sounds like one report would do what you need.
That is about it. See this article for more info.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |