Skip to main content

    Power BI

    New

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

    Vote (221) Share
    sreinman's profile image

    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 (26)
    sreinman's profile image Profile Picture

    Kristoffer Absalonsen on 05 Jul 2020 22:57:10

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

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

    sreinman's profile image Profile Picture

    Tyler Becker on 05 Jul 2020 22:52:27

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

    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)

    sreinman's profile image Profile Picture

    twalker on 05 Jul 2020 22:46:27

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

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

    sreinman's profile image Profile Picture

    C C on 05 Jul 2020 22:46:03

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

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

    sreinman's profile image Profile Picture

    kiwi on 05 Jul 2020 22:41:11

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

    Must have

    sreinman's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:33:22

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

    bump.....?

    sreinman's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:30:31

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

    so...it has been "planned" for nearly a year...any news?

    sreinman's profile image Profile Picture

    Pedro Innecco on 05 Jul 2020 22:29:44

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

    We need this for, like, yesterday!

    sreinman's profile image Profile Picture

    joost.raaphorst@topbi.nl on 05 Jul 2020 22:27:14

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

    Any feedback on when this feature might roll out? Thanks!

    sreinman's profile image Profile Picture

    Mitsu Madhani on 05 Jul 2020 22:24:49

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

    Please start on this Soon ... it is a must have feature ...