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.
Dear All, good morning.
Wanted to have an input from all of you about the current issue I am facing. I do need to create a report containing all KPI's created on different reportwithin the company.
The current issue I am facing is, there are more than 10 report, each with it's own logic dataset and visuals, I need to place all of the KPI's in another new report.
What is the best solution and approach for this case? Creating a KPI page within every report and afterwards consolidating into a dashboard? I did not like this approach as you do not have that much way to configure a dashboard visually compared to reports...
Thank you in advance!
Solved! Go to Solution.
@Anonymous , If you do not want dashboard
Are these datasets overlapping, if yes, merge using ALM toolkit.
How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc
If not add multiple datasets (power bi service dataset( as a direct query), remove duplicate. Copy paste visual in this new power bi file
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
@Anonymous , If you do not want dashboard
Are these datasets overlapping, if yes, merge using ALM toolkit.
How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc
If not add multiple datasets (power bi service dataset( as a direct query), remove duplicate. Copy paste visual in this new power bi file
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |