topic Re: Same Dataset for multiple reports in Power BI Report Server? in Report Server

Same Dataset for multiple reports in Power BI Report Server?

adimira — Wed, 22 Dec 2021 14:02:58 GMT

Hi,

I have a few different Power BI reports using same dataset published on Power BI Report Server (on prem). Is there a way to use the same dataset for multiple reports with Power BI Report Server?

Thanks,

Mihaela

Re: Same Dataset for multiple reports in Power BI Report Server?

d_gosbell — Wed, 22 Dec 2021 21:34:29 GMT

The only way to do this on-prem in PBIRS is to use SSAS (SQL Server Analysis Services) to host the data model. Then you can create multiple live connected pbix reports back against the one data model. You cannot connect to the data model in a pbix report like you can on the service.

Re: Same Dataset for multiple reports in Power BI Report Server?

adimira — Tue, 04 Jan 2022 14:09:11 GMT

Thank you

Re: Same Dataset for multiple reports in Power BI Report Server?

Anonymous — Wed, 17 Jan 2024 14:45:07 GMT

Is it still true that you need to use SSAS for this?

Re: Same Dataset for multiple reports in Power BI Report Server?

d_gosbell — Sun, 21 Jan 2024 23:30:07 GMT

Anonymous wrote:

Is it still true that you need to use SSAS for this?

Yes

Re: Same Dataset for multiple reports in Power BI Report Server?

Anonymous — Mon, 22 Jan 2024 07:16:59 GMT

Ok, thanks!