Forum Discussion

EricMamet's avatar
EricMamet
Helper I
5 years ago
Solved

Use Power BI data in Excel Pivot table, like an SSAS datasource?

We have many users currently using data from an on premise SSAS model into Excel spreadsheet through Pivot tables.   We would like to "gently" move them towards Power BI rather than pure Excel.   ...
data sources
Excel
SSAS
  • d_gosbell's avatar
    d_gosbell
    5 years ago
    EricMamet wrote:

    Is it possible to use Power BI Report Server models as an Excel datasource the same way we can do with an Analysis Services datasource? 

    No it's not. Report Server does not expose any way to connect to the data model in a pbix report. But what you can do is continue to use SSAS to host the data models and create PBIX reports that are live connected to SSAS. Then you can use a mix of both Excel and Power BI reports.

d_gosbell's avatar
d_gosbell
Super User
5 years ago
EricMamet wrote:

Is it possible to use Power BI Report Server models as an Excel datasource the same way we can do with an Analysis Services datasource? 

No it's not. Report Server does not expose any way to connect to the data model in a pbix report. But what you can do is continue to use SSAS to host the data models and create PBIX reports that are live connected to SSAS. Then you can use a mix of both Excel and Power BI reports.