Username setup

Some authentication methods require a calculated username to be passed from Power BI to WriteBackExtreme.

This is only required when using one of the following authentication methods:

• Username + Password

• Pincode

• No Authentication

Create a username measure

To retrieve the current Power BI user, create a new measure in your semantic model using the following DAX formula:

Username = USERPRINCIPALNAME()

More information about the difference between USERNAME() and USERPRINCIPALNAME() can be found here: https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670

Add the username to the visual

1. Select the WriteBackExtreme visual

2. Open the visual settings sidebar

3. Add the created measure to the Username field

The username will now be passed to WriteBackExtreme during authentication.