shree_harsha
9 years agoNew Member
Status:
Abandoned
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.
95 Comments
- nishalitNew MemberWe'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.
- mstacey
Advocate I
This shared data sources is a huge deal for us - it will simplify deployment and management immensely - aberstudent2002New MemberThis would allow for easy management and updating of data sources without causing a downtime for our customers
- jcpratt2New MemberI have just implemented PBIRS Aug 2017 Preview along with the Desktop RS (June 2017) app. I have a PBIX with live query against an SSAS cube data source. My report security on the server and against SSAS is set up to use a tunnel account, which means specifying specific credentials for the report to run as at runtime. The current desktop app for RS does not allow specifying a shared data source OR specifying credentials. Every time I deploy a change to the report (Save As to the report server), the server-side report's embedded data source settings are overwritten. Once I have both TEST and PROD set up with PBIRS, this will be a very brittle and time-consuming situation as I will have to update the data source settings with every deployment no matter how small the change was. PLEASE add support for both shared data sources for PBIX reports under report server and specifying the data source and/or credentials in the desktop RS app as a priority. This should work just like SSRS report development using Visual Studio, with an IDE connection, a published shared data source which is not overwritten with each report deployment, and the ability to create and use a shared data source on the server.
- nojetlagNew MemberTotally agree, without shared data sources, it doesn't scale for an enterprise environment. Please consider this for the next release of PBIRS.
- edurod27New MemberWhen I create a Data Source in Power BI Server, works perfect. But I can not connect this Data Source that is on the server within my reports. So I have 4 reports that use the same Data Source, and connect them to the shared one. I have read that this Shared Data Source is only available to use for SSRS paginated reports and mobiles reports:
- larryortegaRegular VisitorWe need this so we can advance reports through development, acceptance and production environments. Being unable to use shared data sources is critical for us to deploy PBI to our enterprise.
- jack_lee1New MemberWithout shared data source, it's just painful for the enterprise environment.
- pbiideas1New MemberPlease consider this for the next release of PBIRS.
- pbiideas1New MemberDeployment is currently error-prone and time consuming, having to change the DS for every single report, one at a time. At least if the DataSource table could be in plain text we could at script DS changes more easily.
Recent ideas
Variable Library: Disable default value set.
The Default Value Set in the Variable Library poses a risk. The Default Value Set will silently apply values when no explicit value set has been selected for a Test or Prod workspace. There i...frithjof_v4 hours agoCommunity ChampionNew634Views17likes2CommentsScheduled Refresh for Fabric Mirroring
Current Challenge: Fabric Mirroring runs continuously, leading to unnecessary data replication and higher Snowflake costs. There is no built-in option to schedule mirroring based on specific times o...ram_eternal1896 hours agoRegular VisitorNeeds Votes472Views3likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen7 hours agoAdvocate INew263Views42likes1CommentWhy are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner9 hours agoNew MemberNew8Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor11 hours agoSuper UserNew17Views2likes0Comments