Query Folding in Power BI & Parameters for flexibility in Power BI
You’re probably applying a lot of steps over and over again every time you create your Power BI report. A waste of time! Apply parameters on the back-end in Power Query, but also in the front-end in your report to make your solutions much more flexible.
This session will give you examples on where you can use parameters in Power BI and which advantages this will have for you.
In this session:
– Power BI desktop
– Power Query
– Power BI Service
– What IF Scenarios
– PowerShell Cmdlets for Power BI
– Power BI API
(optional items depending on time and audience)
Power Query allows you to extract and transform data from a variety of data sources. Have you ever experienced that the importing of data is slower than you expected? In most of those cases, query folding is not happening fully optimized.
Query folding is important because it offloads data transformations to the source, instead of performing them in Power BI.
Attend this session to learn how to ensure that you get all the performance improvements possible within your reports! As an added bonus, you will also learn in which cases query folding is not your best friend.
Data Platform MVP, Power BI enthusiastic, public speaker and passionate for everything which transforms data into action! Working at Macaw in the Netherlands as a Data & AI consultant.
What I like the most? Sharing my thoughts, experience, best-practices and enthusiasm about Microsoft dataplatform with others. I mostly do this in public speaking at usergroups, conferences, customer presentations and end-user training. Besides that I also have my own blog which you can find at https://data-marc.com/
Nicky van Vroenhoven is a BI professional focused at the Microsoft stack. He mainly works with Power BI, Biml and T-SQL. After working 9 years in BI-consultancy jobs in several industries and companies, he is currently working as a Lead BI Developer at the DWH team at Van Lanschot Kempen in The Netherlands. Nicky has spoken at several User Groups, SQL Saturday Events, and the Power BI World Tour about Power BI. In addition he enjoys tweeting and blogging about topics like Power BI, Power Platform, DAX and SQL Server at nickyvv.com.
|18u30||Welcome and introductions|
|18u45||Use parameters to add extra flexibility to your Power BI content (60 minutes)|
|20u00||Query Folding in Power BI (60 minutes)|