Apply Row-Level Filters via URL in Bold BI

Easily filter data in your Bold BI dashboards using the embed_datasource_filter parameter in the iFrame URL. This feature allows you to customize data views for users based on their roles or permissions, enabling Row-Level Security (RLS)

How It Works

• Add the embed_datasource_filter parameter to the iFrame URL.
• Use && for dashboard parameters and & for URL parameters.
• Parameter names must match the dashboard’s column names exactly and are case-sensitive.

Examples

Filter by Dashboard Parameter

Show only data for the Sales department:

<iframe src="http://localhost:51777/bi/site/site1/dashboards/5cfde98c-d352-4863-8a93-d6679263191b/Sales/Sales%20Analysis%20Dashboard?isembed=true&embed_datasource_filter=&&Department=Sales" id="dashboard-frame" width="100%" height="100%" allowfullscreen frameborder="0"></iframe>

Filter by URL Parameter

Show only data for the North region:

<iframe src="http://localhost:51777/bi/site/site1/dashboards/5cfde98c-d352-4863-8a93-d6679263191b/Sales/Sales%20Analysis%20Dashboard?isembed=true&embed_datasource_filter=&Region=North" id="dashboard-frame" width="100%" height="100%" allowfullscreen frameborder="0"></iframe>

Filter by Both Dashboard and URL Parameters

Show data for the Sales department and a specific user ID:

<iframe src="http://localhost:51777/bi/site/site1/dashboards/5cfde98c-d352-4863-8a93-d6679263191b/Sales/Sales%20Analysis%20Dashboard?isembed=true&embed_datasource_filter=&&Department=Sales&UserID=123" id="dashboard-frame" width="100%" height="100%" allowfullscreen frameborder="0"></iframe>

Filter Syntax Reference

Use the table below to understand how to structure the embed_datasource_filter parameter for different scenarios.

Note: Ensure parameter names match your dashboard’s column names exactly, as they are case-sensitive.