In this video, we look at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop. This feature is incredibly powerful when it comes to data matching and can be adjusted to meet your needs.
In this video, Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh. MEQM Files - https://github.com/guyinacube/demo-files/tree/master/video%20demos/MEQM
Fun with DAX – Minesweeper (@PhilSeamark) Power BI Visuals Reference (@marcorus) Comparing Rows in Power Query Part 1 (@PowerPivotPro) Developing with Power BI Embedding (Part 1) (@criticalpath) See Power BI Preview Features in action at the Power BI World Tour BONUS ITEMS: Can You Use Power Query In Power BI Or Excel To Write Data [...]
Center the X-Axis on a Line Chart (@Seth_C_Bauer) 'What If' Analysis Techniques For Power BI (@Enterprise_dna) Happy Birthday Power Query (@ExceleratorBI) Power BI Service and Mobile June Feature Summary Power BI expands self-service prep for big data, unifies modern and enterprise BI BONUS ITEMS: User Specified Growth on an Investment using Power BI (@ExceleratorBI) Creating [...]
Fun with DAX – Sudoku (@PhilSeamark) Custom Web Fonts and Icons in Power BI (@dataveld) POWER BI REPORT SERVER DEVOPS (Trisha McCormick) Automatically expand all fields from a JSON document in Power BI and Power Query (@TheBIccountant) Correct calculate of age in DAX from birthday (@marcorus) BONUS ITEMS: Segmented Filtering with Slicers (@PowerBITips) More Details [...]
Power BI Quiz (Test Prep for Certification) (@rsaprano) The definitive guide to ALLSELECTED (@FerrariAlberto) Share reports with your teams and partners Connect to tens of thousands of datasets on data.world with the new connector for Power BI Desktop Power BI Desktop February Feature Summary BONUS ITEMS: Joining tables In Power BI using Power Query and/or [...]
Power Query – Consecutive Days (@PowerPivotPro) The Each Keyword in Power Query (@kpuls) Remove repeating characters from a string in Power BI and Power Query (@TheBIccountant) "In the Previous" Date Filters In Power BI/Get&Transform/Power Query (@cwebb_bi) Query folding to improve Power BI performance (@CurbalEN) Power BI Desktop January Feature Summary BONUS ITEMS: Adding Comments & [...]
In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX. Chris Cook - @Finalyst89 Scott Senkeresty – @ScottSenkeresty Dynamically changing chart axis http://tinylizard.com/dynamically-changing-chart-axis/
In this video, Adam looks at how to use conditional columns within Power Query and then copying them for use in other queries or Power BI Desktop files. This is a great technique if you don't want to retype all of the conditional items in the dialog in Power BI.