Skip to main content
Microsoft Idea

    Power BI

    Declined

    Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Vote (451) Share
    Harsha's profile image

    Harsha on 03 Jul 2017 11:21:18

    Currently each Power BI report published to the Report Server has its own data source embedded within the report. Any change in the source would require us to change hundreds of published reports individually. Could we have a shared data source/connection similar to SSRS Reports that would help us manage deployment and changes much more efficiently.

    Administrator on 01 Apr 2019 23:38:54

    We're not planning to make this feature available in Power BI Report Server. We are looking at making available an API to allow you to change the data source programatically, however, to make movement between servers easier.

    Comments (93)
    Harsha's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:21:19

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    I totally agree - Why not just use the .pbit (powerBI template) file as a connector for PowerBI, SSRS & excel? Publish it to a central repository and all tools can connect and deliver aggregated or big dump reports based on this. SSAS Cubes have a model but they are way to slow to use for dump reports since MDX is not designed for this.

    Harsha's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 23:21:07

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Very much needed functionality!

    Harsha's profile image Profile Picture

    Hitesh Patel on 05 Jul 2020 23:20:59

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Been under review for 10 months now, much needed functionality, please add this on to roadmap asap.

    Harsha's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:20:51

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Massive shortcoming having to set the credentials for every report individually.

    Harsha's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:20:06

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    This is a huge need. Please implement this functionality.

    Harsha's profile image Profile Picture

    Kel Varnsen on 05 Jul 2020 23:19:49

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    This is a critical feature! Please implement ASAP.

    Harsha's profile image Profile Picture

    Yol3 on 05 Jul 2020 23:19:16

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Please consider this for the next release of PBIRS . ASAP

    Harsha's profile image Profile Picture

    Mark on 05 Jul 2020 23:19:04

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    definitely needed

    Harsha's profile image Profile Picture

    CogBi on 05 Jul 2020 23:18:33

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    I see that this has been under review for over 9 months, is there an update?
    Would this functionality be forth coming?
    Very interested to see this working and then it would be enterprise ready.

    Harsha's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:17:54

    RE: Shared data source connection (live to Tabular SSAS) for reports published on Power BI Report Server

    Super surprised that this feature was lost from SSRS to PowerBI Report Server. This is a must in order for us to proceed with moving to a production implementation. Please implement ASAP.