Skip to main content

    Power BI

    Planned

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

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

    0b858ea8 542b-4165-9a89-aacf6bb70b0b 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

    6506ed81 47e4-483d-bb2f-e0eecae741a2 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

    515793d9 7ca5-46bd-a9a4-38805e55baeb 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

    307f7a11 88c4-4e46-a376-acfa04c88a15 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

    307f7a11 88c4-4e46-a376-acfa04c88a15 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

    1f7f2711 5819-e611-80e2-c4346bad91c4 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

    c236b214 dff0-4bab-91b6-34fcd4a0020a 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

    b032b6a6 4405-4366-9594-68b579b912f2 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 ...

    sreinman's profile image Profile Picture

    307f7a11 88c4-4e46-a376-acfa04c88a15 on 05 Jul 2020 22:23: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

    67a4abbe 3272-401e-96df-b28122c408e0 on 05 Jul 2020 22:22:00

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

    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.