How can we improve Power BI?

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

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.

184 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

sreinman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

24 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    Agreed with previous comment -- I was really surprised that this didn't work when I published a workbook with a live SSAS connection to Power BI. Is this still planned? An update from the product team would be appreciated!

  • Dane commented  ·   ·  Flag as inappropriate

    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.

  • Edward Miles commented  ·   ·  Flag as inappropriate

    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

  • Anonymous commented  ·   ·  Flag as inappropriate

    +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

  • Jonathan Åkerblom commented  ·   ·  Flag as inappropriate

    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.

  • Tyler commented  ·   ·  Flag as inappropriate

    Any update, a number of organizations have investments in Excel reports which are tied back to SSAS, would be great if Power BI would support these instead of having to port them over to Power BI (which is not as good as Excel for viewing big tables of data)

  • twalker commented  ·   ·  Flag as inappropriate

    It would be nice to also include ability for Excel files sourced from a Power BI dataset to connect live to the dataset.

  • Hikmer commented  ·   ·  Flag as inappropriate

    When will this be road mapped? PP and PQ are clumsy ways to connect Excel to on premise data.

  • Jeff Stott commented  ·   ·  Flag as inappropriate

    I agree this is a MUST HAVE feature to make PowerBI a true enterprise class portal and allow us to get full adoption with our users.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.