Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
PPStar
Helper V
Helper V

Deployment Pipeline help

Hello. I have a deployment pipeline in Power BI. 

 

I want to give end users access to the Exploratory Workspace, however, i want to ensure they dont use the reports in this workspace for 'real reporting'.  i need to way to ensure that users are aware Exploratory and that ANYTHING in this workspace is not supported. 

 

What is the best way to acheive this?

 

 

1 ACCEPTED SOLUTION

Hi @PPStar 


Thanks for the clarification, makes sense. In that case, I suggest the following approaches:

 

1) Use Dataset Endorsement -> In Power BI Service, datasets can be endorsed as "Promoted" or "Certified." Use these flags for production-ready data, and ensure that this dataset is not endorsed, so users know it's not an official or approved dataset.

 

2) Define and communicate a Dataset Expiry date -> If the dataset is temporary, consider setting an expiration date for it. State that after this date, the dataset can/will be automatically removed or flagged for review.




Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

View solution in original post

3 REPLIES 3
pmreis
Super User
Super User

Hi @PPStar 

If you aim to grant access to both datasets and existing reports but ensure  they are not used for production purposes, my suggestion is to flag existing artifacts:

 

1. Naming Convention: -> Start by naming the workspace clearly to indicate its purpose. For instance, you could name it "Exploratory Workspace - NOT FOR PRODUCTION".

 

2. Workspace Description: -> Use the workspace description to clearly state its purpose. Mention that the reports and dashboards within are not supported and should not be used for official reporting.

 

3. Report Watermark: -> Add a watermark to all reports in the exploratory workspace. This can be a text box or an image that says "EXPLORATORY - NOT FOR PRODUCTION" placed in a prominent location on each report page.

 

4. Notification Banner -> If you have the capability, add a notification banner at the top of each report, reiterating that the report is for exploratory purposes only.

 


If you aim to grant access just to reports, you might consider granting access exclusively via APP.
If you aim to grant access just to datasets,  you might consider disabling build permissions and/or having a separate workspace outside the deployment pipeline as a sandbox for the users.

 


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

Thank you so much for your response. 

Whilst i agree with all of the above, this will work for the actual report. 

However, once they have access to the dataset, nothing stops the users from connecting to the dataset using a Live Connection and then build their own reports. 

 

How can we ensure the dataset in EXP is clearly states that data is not production ready. 

 

Hi @PPStar 


Thanks for the clarification, makes sense. In that case, I suggest the following approaches:

 

1) Use Dataset Endorsement -> In Power BI Service, datasets can be endorsed as "Promoted" or "Certified." Use these flags for production-ready data, and ensure that this dataset is not endorsed, so users know it's not an official or approved dataset.

 

2) Define and communicate a Dataset Expiry date -> If the dataset is temporary, consider setting an expiration date for it. State that after this date, the dataset can/will be automatically removed or flagged for review.




Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.