cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EricMamet
Helper I
Helper I

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.

 

Having said that, we must continue providing them the ability to use Excel if they wish (with linked rather than exported data).

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? 

1 ACCEPTED SOLUTION
d_gosbell
Super User II
Super User II


@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.

View solution in original post

4 REPLIES 4
EricMamet
Helper I
Helper I

Thanks

josef78
Continued Contributor
Continued Contributor

Hi,

as d_gosbell wrote, is not possible direct connect to PBI model stored in Excel file, but you can use SSAS Tablar to host this models.

Additional important information, you can easy migrate Excel Power BI model to SSAS, using migration wizard project in Vistual Studio SSDT.

Thank You.

d_gosbell
Super User II
Super User II


@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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors