BI Power Hour Quick Tips for Aggregations & Composite Models in Power BI (@GilbertQue) Create a Power BI Slicer Panel (@ExceleratorBI) Create Event Calendar In Power BI (@DhruvinShah16) On-premises data gateway October update is now available Power BI Desktop October 2018 Feature Summary BONUS ITEMS: Transform NAV accounts totaling to list of accounts (@TheBIccountant) Optimizing [...]
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, we are joined by Buck Woody. Buck is a data scientist at Microsoft. We work together to show how you can easily visualize Microsoft R in Power BI. We use Microsoft R Open and then move onto Power BI Desktop. The example used in Microsoft R Open is the Anscombe's quartet. Download [...]
Are you using Power BI incremental refresh? Have you had it not work even though you set everything up? In this video, Patrick looks at a scenario where Power BI incremental refresh was broken. He then looks at a way to get Power BI incremental refresh working properly.
Working with big data, even massive data can be a real challenge in Business Intelligence platforms. #PowerBI is no exception. The new aggregations feature in Power BI looks to solve that problem. We sit down with Christian Wade, the Power BI PM that brought us Clicky Clicky Draggy Droppy, and who is the PM for [...]
Visually Appealing Power BI Reports (@ExceleratorBI) So, You’re Getting a Data Warehouse for Power BI… (@PowerPivotPro) Power BI Developer community September update Deep dive in the organizational custom visuals POLITICO Europe bets on Microsoft Power BI to report on the European Union Elections BONUS ITEMS: SIMPLE STEPS TO EMBED IMAGES IN POWER BI (@ZacharyConroe) Loading [...]
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 [...]
Reference vs Duplicate in Power BI; Power Query Back to Basics (@Rad_Reza) Power BI Cheat Sheet (@DaveRuijter) #PowerQuery everywhere :-) – now in #microsoftflow as well (@donsvenson) Premium Capacity Metrics app – query metrics now available Introducing Power BI Home & Global Search Bonus Items: Power BI InfoGraphic Update – Sep 2018 (@GilbertQue) Power BI [...]
Switching a report from one PowerBI dataset to another PowerBI dataset (@donsvensen) Get data from PDF in Power BI (@CurbalEN) Using Dax To Handle Multiple Parent Hierarchies (@PowerPivotPro) DAX Guide – the reference I had been wanting (@marcorus) https://dax.guide On-premises data gateway September update is now available Bonus Items: Converting Decimal Numbers To Hexadecimal In [...]