In this training session, Nate Halliwell from Pragmatic Works walks through a powerful but often overlooked feature in Power BI: URL parameters. The focus of the video is on how Canvas Apps can dynamically filter embedded Power BI reports based on user interaction, creating a more responsive, intuitive, and connected analytics experience.
By passing filter parameters directly through the Power BI report URL, app builders can ensure that report visuals update instantly as users make selections inside the app. This approach removes friction, improves usability, and allows business users to explore data naturally without manual filtering.
Nate begins by demonstrating a simple Canvas App layout. The app contains a gallery on the left displaying account names and an embedded Power BI report on the right. The goal is straightforward: when a user selects an account from the gallery, the Power BI report should automatically filter to show only the data related to that account.
If no account is selected, the report should display all available data. This behavior ensures flexibility while keeping the experience clean and intuitive for the end user.
While Power Apps offers a Power BI Tile control, Nate explains that developers are not limited to tiles alone. By accessing the advanced properties of the control and using the Tile URL property, app builders can embed a full Power BI report instead of a static tile.
Using the embed URL from Power BI provides several advantages:
This setup allows Canvas Apps to feel like a seamless extension of Power BI rather than a disconnected viewer.
The core of the training focuses on dynamically filtering the embedded report using URL parameters. Nate explains that URL parameters follow a specific structure where each parameter is added after a question mark and separated using an ampersand.
To filter a report, Power BI supports a filter parameter that uses OData syntax. This syntax requires specifying:
Initially, Nate demonstrates a hardcoded filter value to confirm that the filtering logic works correctly before making it dynamic.
A common frustration when working with URL filters is that filters may appear correct but still fail silently. Nate explains that this often happens when table or column names contain special characters, such as spaces.
Power BI requires these characters to be explicitly escaped using specific syntax. For example, spaces in table or column names must be replaced with an encoded value defined in Microsoft documentation. Once this escape sequence is applied correctly, the filter begins working as expected.
Nate emphasizes the importance of carefully reviewing Microsoft Learn documentation rather than skimming it, as small syntax details can prevent filters from working entirely.
After confirming the filter works, Nate updates the URL formula to pull the selected value directly from the Canvas App gallery. This allows the report to update dynamically as users click different records.
With this change, selecting different accounts immediately updates the Power BI visuals. The app now behaves as a truly interactive analytics solution rather than a static embed.
Another challenge arises when the filter value itself contains special characters, such as apostrophes. Nate demonstrates how values with apostrophes can cause the filter to fail silently, even though no error is shown.
To resolve this, special characters within values must also be escaped. In the case of apostrophes, Power BI requires replacing a single apostrophe with two apostrophes. Nate applies a substitute function within the Canvas App formula to handle this automatically.
Once implemented, filtering works reliably even for records with special characters in their names.
Nate concludes by recommending that app builders proactively handle special characters rather than reacting to issues later. This can be achieved through:
While the demo focuses on simple equals filters, Power BI URL parameters support more advanced scenarios such as filtering multiple values or using different comparison operators. Nate encourages viewers to explore these options and take advantage of live training opportunities available through the Pragmatic Works On Demand Learning platform.
This session highlights how thoughtful use of URL parameters can dramatically enhance the integration between Power Apps and Power BI, delivering smarter and more engaging analytics experiences.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.