Let's say you want to filter a report to show data for a customer named "Smith & Jones Co."

Step 1: Write the filter in plain text

First, write out the filter using Power BI's OData filter syntax. TableName/ColumnName eq 'Value'

In our example, this would be: Customers/CustomerName eq 'Smith & Jones Co.'

Step 2: Identify the special characters that need encoding

Look at your filter string: Customers/CustomerName eq 'Smith & Jones Co.'

The special characters are:

• / (forward slash)

• (space)

• & (ampersand)

  Step 3: URL Encode those characters

  Now, replace them with their encoded equivalents. Here are some common ones:

  Character	Encoded Value
  $	%24
  /	%2F
  (space)	%20
  &	%26
  ' (single quote)	%27
  +	%2B Applying this to our filter: Customers**/**CustomerName eq 'Smith **&** Jones Co.'` becomes... Customers%2FCustomerName eq 'Smith%20%26%20Jones Co.' Step 4: Assemble the final URL Now, build the full URL by attaching your correctly encoded filter. Base URL + ? + standard parameters: https://app.powerbi.com/reportEmbed?reportId=your_report_id&autoAuth=true  Add the filter parameter (&$filter=): &$filter= Append your encoded filter string: Customers%2FCustomerName%20eq%20'Smith%20%26%20Jones%20Co.' Your final, correct URL would be https://app.powerbi.com/reportEmbed?reportId=your_report_id&autoAuth=true&$filter=Customers%2FCustom... 20'Smith%20%26%20Jones%20Co.'

•  

•