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.

439 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Harsha shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

72 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Tony Taylor commented  ·   ·  Flag as inappropriate

    Having used the Power BI Service in other organisations, to publish a PBIX containing data, then creating reports using that "Power BI Dataset" is great.
    Why could that functionality not be made available in PBIRS? Security restrictions do not allow us to use the Power BI Service.

  • Romain commented  ·   ·  Flag as inappropriate

    As I understand there will never be shared data sources for Power BI reports, it will only work for paginated reports. It's a big weakness to consider when comparing to Tableau and Qlik. At least It would have been great to have predefined datasources that could be downloaded from the server.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Thanks for the response Chris - I'd be happy if that response was an April fools joke, but sadly I don't think it is :-(.

  • Jack commented  ·   ·  Flag as inappropriate

    @ChrisFinlan
    The suggested API solution doesn't work well within an enterprise environment.

    We have common Power BI prod & dev environments shared between multiple business streams (1 level above departments). As a "content manager" for 1 business stream, I don't have the access to programmatically access the Power BI prod or dev environments, because the information content (dashboards containing data cache) is not supposed to be shared between business streams. The responsibility of developing programmatic access falls back to Power BI admins, who often have other priorities. So, the suggested API approach is not empowering the "content managers".

    Would you please reconsider the requested feature?

  • Mike Foss commented  ·   ·  Flag as inappropriate

    CNames can help in this situation since MS isn't willing to added existing features. Your network admins can help create CNames to point to servers so if the server changes in the future you can just repoint CName.

  • Sheng Zhu commented  ·   ·  Flag as inappropriate

    Dear Power BI Report Server Team,

    I believe this feature is very important for any big organisations who are currently embracing DevOps solution and have multi environments (DEV, UAT,PROD) to consider during deployment.

    We have tried all type of work around including unzip/rezip the pbix file in current deployment pipeline, but the result is not good.

    The earlier you can implement this feature, the less hassles for large organisations who already chose Power BI as the official BI tool.

    Regards,

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

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