210
s

Add ability for Excel workbooks to have a live connection to SSAS

sreinman on 12/11/2015 1:10:56 AM
210
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.
STATUS DETAILS
New

Comments

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Kamil Kozioł on 2/2/2023 3:56:56 PM

Still no updates?

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

JJ on 7/6/2020 12:15:05 AM

planned since 2016 lol ;)

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

JJ on 7/5/2020 11:27:09 PM

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

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Alistair Brown on 7/5/2020 11:26:19 PM

I see this has been planned since March 2016. Any update on this?

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Dane on 7/5/2020 11:19:49 PM

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.

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Power BI User on 7/5/2020 11:17:43 PM

Any progress on this ?

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Edward Miles on 7/5/2020 11:14:08 PM

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

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Power BI User on 7/5/2020 11:01:49 PM

'+1 absolut missing feature... "Analyse in Excel" is only the half story if you are not able to publish the excel file back to 0365 without "breaking" the refresh-ability

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Jonathan Åkerblom on 7/5/2020 11:00:51 PM

The business case I have for my organisation is to upgrade our Report Server with the PowerBI Report Server version, and to use this as a platform for all our reports. Be it SSRS reports, KPIs, PowerBI reports or Excel reports. I would be able to view all of these in one portal. As of today you have implemented this viewing functionality for PowerBI reports, but you still lack a simple way to view Excel reports. Our end users have to download the excel reports as static files from our report server, which only leads to excel hell. ->> If I could publish the excel reports (that all have SSAS connections) to PowerBI.com and then be able to interact with these excel workbook reports through the Report Server, the same way that I interact with regular PowerBI reports --- Then! I'd have a strong business case. But since this SSAS live connection thing doesn't work, I have zero use for the integration between SSRS, PowerBI and Excel.

s

s

RE: Add ability for Excel workbooks to have a live connection to SSAS

Kristoffer Absalonsen on 7/5/2020 10:57:10 PM

This should also include Excel workbooks connected to datasets in Power BI Service.