How should I create a dashboard that uses different datasets?

[Pedro_Okazaki]

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!

[amitchandak · Accepted solution]

@Pedro_Okazaki , 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