#BIPowerHour, Tips, Slicer pane, Power BI Desktop and Gateway updates, more… (October 29, 2018)

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 [...]

#BIPowerHour, Tips, Slicer pane, Power BI Desktop and Gateway updates, more… (October 29, 2018)2018-10-29T09:03:04+00:00

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.

Fuzzy match / merging in Power BI Desktop (October 2018)2018-10-24T08:32:07+00:00

Microsoft R, Data Science and Power BI

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 [...]

Microsoft R, Data Science and Power BI2018-10-23T09:18:29+00:00

Case of the Broken Power BI Incremental Refresh

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.

Case of the Broken Power BI Incremental Refresh2018-10-17T07:50:21+00:00

How to use the Power BI Aggregations Feature

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 [...]

How to use the Power BI Aggregations Feature2018-10-14T15:58:07+00:00

Design Power BI reports, Data Warehouse updates and more… (October 15, 2018)

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 [...]

Design Power BI reports, Data Warehouse updates and more… (October 15, 2018)2018-10-14T15:39:35+00:00

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

Mashup Engine Query Monitor for Power BI Refresh2018-10-10T09:30:12+00:00

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 Minesweeper, Visual reference, World tour and more… (October 8, 2018)2018-10-08T07:28:35+00:00

Power BI Cheat Sheet, Power Query in MS Flow, Home and more… (October 1, 2018)

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 [...]

Power BI Cheat Sheet, Power Query in MS Flow, Home and more… (October 1, 2018)2018-10-01T04:33:00+00:00

Power BI datasets, DAX, gateway update and more… (September 24, 2018)

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 [...]

Power BI datasets, DAX, gateway update and more… (September 24, 2018)2018-09-24T09:20:46+00:00