publish to power bi web confidential information

Publish to power bi web confidential information professional#

The testerĬan test the data but cannot view the sensitive column information, while the sameĬolumn is viewable by the business user once it is deployed to the designated workspace.

The overall process should be transparent for the business user but shouldĪn example scenario is when the final checks are being performed.

The business user is also a database user who can view sensitive data in.

We need to create a database user who can view the sensitive data in a masked.

Now, masking and unmasking within the database itself achieve the desired objective Database Strategy to Mask and Unmask Data for Testing and Publishing Tester does his job, and the report finally gets deployed to the designated workspaceįor the business user to consume. Since we want the tester to test the report (data) without seeing the actualĭata (for specific sensitive visuals) and the business user to view the data withoutĪny trouble, we have to switch between masking and unmasking (sensitive) data. The business user is the user who is going to consume the reporting solutionīy viewing and analyzing the data in the form of a Power BI report. The report is about to be published to the target side, which is a specific type The tester must connect with actual data because

In the scenario itself, as we are in the final stage of testing the report justīefore deployment to production. One might argue why we cannot use test data for the tester. The purpose, but at the same time, they are not supposed to see the sensitive data Let's discuss the simple roles of the tester and business user in a PowerĪ Power BI tester is supposed to test a Power BI report to ensure that it serves

Publish to power bi web confidential information professional#

It to a full-fledged professional life scenario. In this tip, but in no way does this simple scenario limit your capability of porting We are particularly focused on a simple scenario of testing a Power BI report Practice and defining principles that work for you.

However, there is a thin line between adopting a standard The role of a tester and a business user is very much the same in every reporting Role of Tester and Business User in a Reporting Solution Using the masking and unmasking database feature for testing, implementation,Īnd viewing the Power BI report ensures that the testers cannot view sensitive information.Īt the same time, this feature allows business users to view their sensitive data