Skip to main content
Microsoft Idea

Power BI

Completed

Need a way to test a dashboard before releasing to production.

Vote (398) Share
Jie jayang's profile image

Jie jayang on 26 Nov 2014 14:43:52

Need a way to test a dashboard (some sort of a dev environment) before releasing (to production environment). This is especially critical in enterprise settings, where any change to the dashboard will likely have large business impact affecing a large number of people.

Administrator on 15 Jul 2023 13:07:00

The asnwer is deployment pipelines

Comments (10)
Jie jayang's profile image Profile Picture

mshoesmith on 05 Jul 2020 22:36:55

RE: Need a way to test a dashboard before releasing to production.

Is there a timeframe for a preview release/GA of this feature?

There needs to be a way in the Power BI service to configure multiple 'environments', to allow iteration through these as part of any integration test/UAT/pre-prod/Prod deployment pipeline.

Many of our clients are looking to us for guidance on best practices around Power BI release & configuration management and this is a significant omission at present,
particularly for clients in verticals where regulatory compliance reporting and change control processes are intertwined and is an impediment to wider adoption.

Jie jayang's profile image Profile Picture

Peer Grønnerup on 05 Jul 2020 22:26:54

RE: Need a way to test a dashboard before releasing to production.

This cannot be done by using content packs. I we change a connection string from i.e. production to test in a PBIX file and re-publish it the change in the connection string will be applied to the content pack. It looks like the update function for content packs only applies to dashboards, reports and datasets. Not the the connection strings them selves.

Jie jayang's profile image Profile Picture

Power BI User on 05 Jul 2020 22:22:12

RE: Need a way to test a dashboard before releasing to production.

Any time frame/date by which this pre-release test environment will be released?

Thanks

Jie jayang's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:06

RE: Need a way to test a dashboard before releasing to production.

Mostly the developers would be developing the reports based on junk data or a snapshot of production / UAT instance. And if a report is published as such, it wouldn't point to production. Developing on production instance again is not an option ( ISMS issues ).

Before deploying, there should be an option to configure against the production. Or the connection string configurable as required.

Jie jayang's profile image Profile Picture

Ajay Anandan on 05 Jul 2020 22:08:25

RE: Need a way to test a dashboard before releasing to production.

You can do this with org content packs, no? You can edit a dashboard, but a recipient will see it only after you update the content pack.

Jie jayang's profile image Profile Picture

Christopher Woodward on 05 Jul 2020 22:05:44

RE: Need a way to test a dashboard before releasing to production.

I would suggest creating a new Outlook Group and only add the test users into it. Then when you publish a content pack, you can subscribe only that Outlook group to the pack to test.

Jie jayang's profile image Profile Picture

Michael Steineke on 05 Jul 2020 22:01:48

RE: Need a way to test a dashboard before releasing to production.

Changing datasource and copy/export the report/dashboard would both be useful for dev lifecycle. Permissions on who owns a report is also less that desirable

Jie jayang's profile image Profile Picture

Achal Anjaria on 05 Jul 2020 21:57:49

RE: Need a way to test a dashboard before releasing to production.

May be you can add "publish" feature and versioning on objects like in SharePoint. Unless its published its in draft status not visible to those shared.

Jie jayang's profile image Profile Picture

Daragh Fitzpatrick on 05 Jul 2020 21:57:32

RE: Need a way to test a dashboard before releasing to production.

Consider creating a 'beta'/draft site separate from 'release'/final. Yes, they're both in production, but consider that this is considered to be a self-service tool, not a developer tool - i.e., business users using production data directly. This requires an Agile methodology, does not allow for Waterfall, and specifically PROHIBITS SDLC which is the whole reason business doesn't want IT doing this.

Jie jayang's profile image Profile Picture

Derrick Han on 05 Jul 2020 21:57:00

RE: Need a way to test a dashboard before releasing to production.

And a way to quickly change data source from UAT/TEST to PROD while maintaining the same data model and chart formatting will be extremely helpful. Currently, changing data source might destroy the data model created