This custom visual has the following 5 main configuration sections:
Config: This section contains all settings required for external connections including the writeback database, Power BI dataset, Premium access and voucher licensing option.
Grid: This section contains all settings relevant for the display and format of the grid including buttons, colors, and messages.
Columns: This section contains all settings available for each single column including formatting and editing options.
Conditional Formatting: This section allows to set 10 formatting and 10 gradients rules which apply from top to bottom.
Data Reduction: This section allows to change the windows how the Power BI custom visual is loading data. By default, the custom visual can load up to 30k rows in each batch which is usually the most efficient option.
Config
- Database type: This drop-down list shows all currently supported databases. Depending on the database chosen, different options might appear, especially for Databricks and Dataverse.
- Database server: This is the host name of the database server you want to change data. The default ports are used, if not otherwise specified by ending the host name with “:port”. E.g. hostname:1443
- Database name: This is the name of the database you want to change data.
- Database table: This is the name of the database table you want to change data including the name of the schema for certain database types.
- Database user: This is the name of the SQL user.
- Database password: This is the password of the SQL user. ****
<aside>
💡
The custom visual component works with an external web service which requires the database to be accessible from outside. Depending on your setup, this might require whitelisting the IP address and open the database ports in the firewall settings. This means, you cannot simply connect to a local database that is not available from the Internet.
</aside>
- Database audit: This option allows to you enable change tracking by automatically adding username and timestamp.
- Current user DAX measure: This is the selected DAX measure holding the current username. e.g. CurrentUsername = USERPRINCIPALNAME()
- User database column: This is the column you want to map the current user DAX measure to.
- Current timestamp DAX measure: This is the selected DAX measure holding the current timestamp. e.g. CurrentTimestamp = FORMAT(NOW(), "yyyy-MM-dd HH:mm:ss")
- Timestamp database column: This is the column you want to map the current timestamp DAX measure to.
<aside>
💡
The username and timestamp as DAX measures to two predefined database fields which are basically added to every change you make in the custom visual grid. In case you also have the predefined database fields dragged into the visual, they are getting overwritten before committing the transaction.
</aside>
- Refresh dataset. Enable automatic Power BI dataset refresh after committing changes, which is especially useful for Import connection mode.
- Refresh dataset type: The Power BI dataset type you want to refresh
- Refresh dataset id: The Power BI dataset id you want to refresh
- Refresh dataset user: The Entra ID user executing the refresh with full access and having MFA disabled
- Refresh dataset password: The Entra ID user password executing the refresh.
- Premium: Enable the Premium licensing option.
- Premium base url: This is the URL of your dedicated back-end which you receive from us directly.
- Premium license key: This is the license key which you receive directly from us directly
- Voucher: Enable the Voucher licensing option.
- Voucher key: This is the license key which you receive directly from us directly.
Grid
In this subsection you will find lots of configurations to adjust the look and feel of the table. Feel free to adjust colors, sizes and other settings to personalize the grid to your needs.
- Enable Add Row: This hides/shows the menu button to add rows.
- Enable Remove Row: This hides/shows the menu button to remove rows.
- Enable Edit Row: This hides/shows the menu button to edit rows.
- Horizontal grid color: The color of the line between the rows in the grid.
- Horizontal grid thickness: The thickness of the line between the rows in the grid.
- Horizontal scrollbar show: This constantly shows the scrollbar on the bottom.
- Vertical grid color: The color of the line between the columns in the grid.
- Vertical grid thickness: The thickness of the line between the columns in the grid.
- Vertical scrollbar show: This constantly shows the scrollbar to the left.
- Row fill color: The background color of the rows in the grid.
- Alternate row fill color: The background color of every second row in the grid.
- Selected row fill color: The background color of a selected row in the grid by the checkbox.
- Hover row fill color: The background color of a row by hovering.
- Header fill color: The background color of the header.
- Wrap text: Breaking up lines of text to fit within column.
- Row height: The height of the of the rows in the grid
- Header height: The height of the header in the grid.
- Font size: The font size in the grid.
- Font family: The font family in the grid.
- Font color: The font color in the grid.
- Menu color: The color of the menu bar.
- Button color: The color of the buttons in the menu bar.
- Checkbox fill color: The background color of the the checkbox.
- Checkbox checked color: The color of the icon within the checkbox when selected.
- Checkbox unchecked color: The color of the icon within the checkbox when not selected.
- Change highlight color: The background of a cell on a change.
- Change highlight time: The time the background is shown of a cell on a change in milliseconds.
- Message highlight time: The time the popup is shown at the top in milliseconds.