topic Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed? in Report Server

Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

QuintonLi — Thu, 13 Aug 2020 01:12:47 GMT

Hi everyone,

I have been working with PowerBI report and dashboard for almost a year now, my supervisors and senior managers are very pleased with PowerBI result and how online dashboard works.

Right now I need to work on about 15 different reports each month and published them into different dashboards for different committees. I will need to published these reports many times, and need to review and correct mistakes many times before sending them out.

Is there any way that I could published these reports just once into something like a "master dashboard", and set up other dashboards to read and show tables and graphes from this master dashboard? This way I only to published all these 15 reports once, and won't need to review and adjust all other dashboards.

Feel free to let me know your best solution to my question. Thanks a lot!

Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

amitchandak — Thu, 13 Aug 2020 02:49:54 GMT

QuintonLi , refer how can you schedule refresh

https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

QuintonLi — Thu, 13 Aug 2020 03:08:59 GMT

Hi amitchandak,

Thanks for your reply, but I don't think schedule refresh could solve my question. I am more interesting in published to one master dashboard so my other dashboards could show the report from that master dashboard after refreshed.

I was told that I could set up different cretencials for different user in that big master dashboard. But I am looking for other possible solution.

Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

josef78 — Thu, 13 Aug 2020 07:16:59 GMT

I'm not sure if understand, but if you want use one master dashboard and other reports share data from this dashboard...? It can be done with dedicated (master) model in SSAS Tabular model. You can create master model in SSAS Tabular model which can be shared to multiple PBI reports or dashboards across PBIRS. Additional benefit is, you can more precisely drive refresh data (per table or incrementally).

Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

QuintonLi — Thu, 13 Aug 2020 22:45:58 GMT

Thanks a lot, Josef78! It's a very good idea for a PowerBI Premium user.

Any other option for a none premium PowerBI user?

Cheers!

Re: Can I publish report once into a "master dashboard", and some other dashboards could auto refreshed?

josef78 — Fri, 14 Aug 2020 07:12:18 GMT

Of course, you can use SSAS server in on-premise enviroment without Power BI Premium. It is ideal on-premise combinataion (SSAS server + PBIRS server), in many cases better than PowerBI Premium.

But you need SQL Server licecences. If you have PBIRS licenced from SQL Server EE with SA, you can also use for SSAS, if not, you need additional SQL Server licences.