Nithya Subramaniam on 25 Mar 2015 10:16:45
Ability to build reports/dashboards pointing to a data source (database in the Development / UAT machine) and then use the same reports/dashboards pointing to another data source (in the Production machine.
- Comments (36)
RE: Re-pointing reports/dashboards at different data sources
It's the whole point of using computers/automation....so we can reuse stuff we made!!
RE: Re-pointing reports/dashboards at different data sources
The same huge problem with SSRS Mobile Reports: when adding dataset, with connection to Test server - then there is no standard clear standard option to repoint report to another dataset (on another server, or f.ex. another location).
RE: Re-pointing reports/dashboards at different data sources
Data source should be editable like SSRS data sources are, so they can be used in multi-environment lifecycles.
RE: Re-pointing reports/dashboards at different data sources
This is a basic fundamental requirement in any BI tool and I am flabbergasted that it is not possible to simply change a connection/data source at the report level on the server you release to...wow!
RE: Re-pointing reports/dashboards at different data sources
All the work done for designing the pages, reports, dashboards, measures, etc using a test database in development is LOST and everything has to be redone to connect to another real data source ??????????????
RE: Re-pointing reports/dashboards at different data sources
Very important.
RE: Re-pointing reports/dashboards at different data sources
I require this too having spent significant time building reports against the data in our test environment.
RE: Re-pointing reports/dashboards at different data sources
This is very much needed. We need to change the data source pointing to UAT or Prod in easy way.
RE: Re-pointing reports/dashboards at different data sources
Please is this feature now available in PowerBI desktop. This is so important and it seems its been "Under Review" for more than 2 Years!!!
RE: Re-pointing reports/dashboards at different data sources
This is important. We build reporting content for dozens of clients - reconfiguring the data source for each of them needs to happen dynamically, or at least with minimal manual intervention.
In SSRS it's easy with shared data sources - the reports run off a named data source which is set up once only for each customer, then the reports deploy seamlessly. It's this concept of a named data source rather than a fully defined data source (with server details, full connection string etc) that's needed.