How can we improve Power BI?

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

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.

366 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Harsha shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Riccardo Muti responded  · 

    Thanks for the feedback! Others, chime in with your votes and comments here.

    52 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Jason Howard commented  ·   ·  Flag as inappropriate

        To echo some of the other comments, this seems like a basic piece of functionality. It is how SSRS has operated for years as well as many competitors. Who embeds a source in each report when you are an Enterprise with hundreds of them?

      • Anonymous commented  ·   ·  Flag as inappropriate

        I concur you should be able to utilize a shared data source just like in Report Builder, Mobile report publisher etc. There are a lot of features in other Microsoft tools that seem to always be left out in newer software. Maybe create a list on common features and include them in all builds.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This functionality is a must. Having to manage credentials per individual reports reduces our security practices as we cannot rotate accounts/passwords

      • Richard D'Angelo commented  ·   ·  Flag as inappropriate

        We currently host over 2,500 SSRS reports on our power bi report server, all of which use shared data sources. We just started on our journey to adding Power BI reports. Not having shared data source connections is something that is keeping us from doing a larger role out. We have to change passwords to sources on a yearly basis and having to do that across a lot of power bi reports manually would be a nightmare.

        Not to mention, we don't have a good way to mange across various environments, i.e. Stage, DEV, QA, etc... Someone wants a power bi report in DEV, we have to manually create all the connections, then when it moves to QA we have to do that same process all over again. It's a lot of redundancy in the report development lifecycle.

      • Phil Bailey commented  ·   ·  Flag as inappropriate

        @Riccardo - could you please provide an update on shared/server-based connections for PBI?

      • James Micallef commented  ·   ·  Flag as inappropriate

        Ideally not just have shared data sources only for PowerBI but be able to share the same data sources across SSRS and Power BI reports.

      • Me commented  ·   ·  Flag as inappropriate

        This should be basic functionality. Not having it is absurd.

      • Mark Stacey commented  ·   ·  Flag as inappropriate

        This is an enormously painful missing feature, for test to prod deploys, for SSAS server migrations, it makes something that should be minutes turn into a huge project.

        It makes things like upgrading to a new version of SSAS much more painful

      • Tom Gilmour commented  ·   ·  Flag as inappropriate

        SSRS already supports Shared Data Sources (and has done for a long time), it would be good if PBIRS could either use the existing SSRS Data Sources, or have an equivalent for PowerBI. Having the data source embedded within each PBI report is not ideal, as others have commented.

      • Sam Greene commented  ·   ·  Flag as inappropriate

        Not having a shared data source is breaking our deployment model based on SSRS. We are typically able to set up the same data source on dev and production and then copy the report from dev to prod without changes by the admin. Now we have to open the report with designer and modify it since we cannot even change the server name through the report manager web interface. Hope to see this soon. Thanks!

      • Ralph Kemperdick commented  ·   ·  Flag as inappropriate

        Here is a cross post as this issue has been raised in other forum as well https://feedback.azure.com/forums/556165-azure-analysis-services/suggestions/17173610-built-in-ssrs-support-for-azure-as
        This a big roll-out blocker for Power BI Report Server paginated reports which cannot not connect to Azure AS. Having Power Query connectors as shared data sources in Power BI Reports server would be a dream !

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is a must in my opinion, for house keeping and trouble shooting.
        I am surprised that it has not been done yet.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Having shared datasources for SSRS has made our over a thousand reports manageable so yes indeed we would like to be able to share any power bi data source the same way

      • Oliver commented  ·   ·  Flag as inappropriate

        This is one of the two reasons currently stopped us to deploy power bi report service.

      • Greg commented  ·   ·  Flag as inappropriate

        Having shared datasources for SSRS has made our over a thousand reports manageable so yes indeed we would like to be able to share any power bi data source the same way.

      ← Previous 1 3

      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.