Forum Discussion

adimira's avatar
adimira
Frequent Visitor
4 years ago
Solved

Same Dataset for multiple reports in Power BI Report Server?

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

 

 

dataset refresh
Power BI Report Server
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    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.

5 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • d_gosbell's avatar
        d_gosbell
        Super User
        2 years ago
        Anonymous wrote:

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

        Yes