Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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.
Thanks
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |