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.

433 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.

    65 comments

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

        Is there any new information that can be shared on this? This is needed for us so that we can reduce the amount of time to move reports from one server to another in the reporting life cycle.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Is there any update on this. Is it possible to create one report and run it for multiple databases by changing the connection string using direct query with OnPremises power bi server?

      • Ioannis commented  ·   ·  Flag as inappropriate

        it seems that Ricardo moved to Google and no-one is following on the request.

      • CF commented  ·   ·  Flag as inappropriate

        This is an absolute must have & will make managing reports a breeze!

      • J. D. commented  ·   ·  Flag as inappropriate

        Surprised this wasn't part of PowerBI from the get go... This is greatly needed.

      • 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.

      ← Previous 1 3 4

      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.