Filtering Power BI Visuals Inside Your Canvas App! скачать в хорошем качестве

Filtering Power BI Visuals Inside Your Canvas App!

Want your Canvas app to control what users see in an embedded Power BI report? In this video, you’ll learn how to use Power BI URL parameters to pass filters straight from a Power Apps gallery into your report—so selecting an account instantly updates maps, tables, and visuals inside the embedded experience. We walk through the exact filter syntax, why filters “silently fail” when you have special characters (like spaces in column names or apostrophes in values), and how to fix it with proper escaping and a simple Substitute() approach. 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ 00:00 Filter embedded Power BI reports using URL parameters 00:21 Canvas app setup: Gallery on left, report on right 00:45 Goal: Select an account → filter the report (or show unfiltered) 01:08 Quick Hit note: similar content on on-demand platform 01:24 Add a containerized screen + Power BI control 01:48 Select workspace/report + make the control responsive 02:07 Use Tile URL vs full Embed Report URL (full report experience) 02:54 The real goal: dynamic filtering from the app 03:11 Connect gallery to the same Dataverse source (Accounts) 03:29 How filtering works: pass filter parameters in the URL 03:52 URL parameter basics: ? and & (reportId, etc.) 04:38 Add the Power BI filter parameter + Learn doc reference 05:26 Filter syntax: Table/Field EQ 'Value' (OData-style) 05:48 Why it fails: special characters in table/column names 06:09 URL encode won’t fix it (save yourself the time) 06:34 Encoding still fails: you must escape special characters 06:57 Escape spaces in column names (_x0020_) 07:26 Filtering works—now make it dynamic from gallery selection 07:54 Dynamic filter demo: selecting accounts updates the report 08:16 Silent failure case: values with apostrophes (Jim's Snacks) 09:00 Escape special characters in values (single quote → double single quote) 09:18 Fix with Substitute() so all values work 09:59 Pro tip: proactively escape common special characters 10:42 Beyond equals: multiple columns/values + advanced filters 11:04 Wrap up + on-demand learning mention Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook: https://prag.works/yt-fb ✔️Instagram: https://prag.works/yt-insta ✔️LinkedIn: https://prag.works/yt-li Pragmatic Works 350 Governor St, Suite 300, Green Cove Springs, FL 32043 Phone: (904) 638-5743 Email: training@pragmaticworks.com #PragmaticWorks