Filter the data in Power BI before you export it to excel using Power Automate

It is finally time to filter Power BI data using the filters in the report before we export it elsewhere, like excel, using Power Automate new step: Run a query against a dataset. Here is the concatenate step, so you can copy it: concat('"', replace(item()?['CategoryName'], ', ', '", "'), '"') If you want to learn more about exporting Power Bi data using Power Automate, check the entire playlist:    • Export data from Power BI   Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI!    / @curbalen   Our PLAYLISTS: Join our DAX Fridays! Series: https://goo.gl/FtUWUX Power BI dashboards for beginners: https://goo.gl/9YzyDP Power BI Tips & Tricks: https://goo.gl/H6kUbP Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ************ MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too! COUPON: CURBAL10 Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance! ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE