sreinman on 11 Dec 2015 01:10:56
At this point, only Excel workbooks with a power pivot data model can work in Power BI. It would be great to have the ability to upload Excel workbooks that are connected to our on-prem analysis services to be refreshable as well. The same way that the analysis services connector works for PowerBI reports, perhaps that connector can be extended to uploaded Excel workbooks as well.
- Comments (28)
RE: Add ability for Excel workbooks to have a live connection to SSAS
Good information, thankssehackear.top
RE: Add ability for Excel workbooks to have a live connection to SSAS
ThanksHackear Instagram Hackear WhatsApp Hackear Facebook
RE: Add ability for Excel workbooks to have a live connection to SSAS
From my perspective, what I want to do is enable workspace users to edit an excel workbook in Power BI service Excel Online or publish to Power BI from excel, and have the workbook be included as a data source in Power BI desktop or in general in reports.Right now, Excel Workbooks don't appear in one lake so it doesn't appear to be a data source even if it appears as a workbook for viewing in Power BI service. In PowerBI desktop there is no way to add a workbook from PowerBI as a dataset, which makes having the workbook in the service somewhat useless in terms of making reports. And that seems like an incomplete Excel Integration..
RE: Add ability for Excel workbooks to have a live connection to SSAS
Still no updates?
RE: Add ability for Excel workbooks to have a live connection to SSAS
planned since 2016 lol ;)
RE: Add ability for Excel workbooks to have a live connection to SSAS
please vote also here in Excel Online Uservoice https://excel.uservoice.com/forums/274580-excel-online/suggestions/33793252-pivottables-created-with-power-bi-using-analyze-in
RE: Add ability for Excel workbooks to have a live connection to SSAS
I see this has been planned since March 2016. Any update on this?
RE: Add ability for Excel workbooks to have a live connection to SSAS
I was surprised when this didn't work - I would have thought this would be the easiest migration path for people working with SSAS data to move from Excel to Power BI.
RE: Add ability for Excel workbooks to have a live connection to SSAS
Any progress on this ?
RE: Add ability for Excel workbooks to have a live connection to SSAS
Any update? It's been planned for a while...
With the workbook section of a workspace it would be a great feature if I could connect a workbook to my Power BI model for those scenarios where Excel is the preferred client