Populate a Power BI parameter list using a query
Patrick shows you how to populate a Power BI parameter list using a query. This can help you avoid manually entering a list, or just having free text.
Visual Vocab, Power Query Keyboard Shortcuts, Power BI Dataflows and more… (December 17, 2018)
Catch the last Power BI roundup for 2018! Merry Christmas, happy holidays and have a great New Year! ?❄? Financial Times Visual Vocabulary: Power BI Edition (@SQLJason) Power Query Advanced Editor keyboard shortcuts (@Dmaslyuk) Power BI Developer community November update Power BI Dataflows and Azure Data Lake Storage Gen2 Integration Preview Power BI Desktop December 2018 [...]
Power BI Desktop: How to find the native query after query folding
Have you wondered how to find the native query in Power BI Desktop after query folding does its thing? Do you even know what query folding is? In this video, Adam looks at how you can find the query that will be sent to your data source and a few things to be aware of. [...]
Fuzzy match / merging in Power BI Desktop (October 2018)
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.
Mashup Engine Query Monitor for Power BI Refresh
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
Power BI Minesweeper, Visual reference, World tour and more… (October 8, 2018)
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 [...]
Power BI Updates, a birthday and more… (July 16, 2018)
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 [...]
Power BI Report Background, Power Query, updates and more… (July 9, 2018)
Quick Tips: Hiding Multiple Columns in Power BI Desktop (@biinsightnz) Iconography in Design (@AdatisBI) How to handle different decimal separator when importing csv files (@donsvensen) Changing outer background of Power BI reports (@Dmaslyuk) Power BI Developer community June update Playgroud: https://microsoft.github.io/PowerBI-JavaScript/demo/ BONUS ITEMS: Efficiently rename columns with a function in Power BI and Power Query [...]
Power BI Sudoku, Custom fonts, DAX and more… (June 25, 2018)
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 Desktop updates, Certificate prep, DAX and more…
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 [...]