Advise on creating a dashboard of dashboards

[klehar]

Hi,

We have like 10 dashboards that we have already created as a team.

Now we are creating an executive dashboard that will a summarized combination of all the above dashboards

Each dashboard has more than 2 data sources and 10 tables minimum

I dont want to reinvent the wheel and recreate the models.

I was thinking I will compile all the dashboard data using pivots and 'Analyze in Excel' 

Then use that single Excel file to build the executive dashboard.

But the excel file from what I know will not refresh automatically.

How can i come around this issue?

Or what other method do you think will be the best in this case?

[Greg_Deckler]

@klehar If you are using actual dashboards, as in Dashboards in the Service, then you can simply go to the original reports and simply pin your visuals to a new executive dashboard.

If you are using dashboards when actually talking about reports, then you should check out DirectQuery for Power BI datasets.

[klehar]

@Greg_Deckler will directquery for datasets let me created additional calculations ?

[Greg_Deckler]

Yes.

[klehar]

@Greg_Deckler I just saw that I can import only 1 power bi dataset at a time. 

Each report I have created has a separate dataset.

[Greg_Deckler · Accepted solution]

@klehar No, that is not correct. When you first connect to a Power BI dataset it is in Live mode. Follow the directions here to put it into DirectQuery mode. Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs

Then you can add another dataset.

[klehar]

Thanks @Greg_Deckler didnt knew this was a new feature that could help

One more thing though, the interface gives me an option to choose selective tables from each dataset that I import.

Later on if I want more tables from a particular dataset, how can I do that?

I'm purposely not importing the entire model thinking it may become heavy

[Greg_Deckler]

@klehar On the Home tab of the Report view, select Recent Sources dropdown and pick your source. You can select/change the tables.