(Livestream Replay) 5 Ways to Get Power BI Data into Excel! None are Copy Paste! - with Wyn Hopkins

ABSTRACT 📄

The reality is folks need / want their data in Excel at some point. While Power BI reduces that need, it still exists. Wyn’s demos will show how to connect using various approaches including a trick to create a connected table with the help of “create formatted table” feature of Power BI, and the largely unknown Featured Table option.

GUEST BIO 👤

Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst”

Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. Wyn’s claim to fame is that he suggested and campaigned for the creation of the XLOOKUP function.

RELATED CONTENT 🔗

Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links

New Way to Apply Conditional Formatting by Category in Power BI!

Video by: Reid Havens

Learn about an update included with the February 2023 release of Power BI Desktop that makes applying conditional formatting by category (text) very easy to do. Before this release a solution like this would require a dedicated DAX measure to convert categories (text) to numbers before using it in the conditional formatting menu.

(Livestream Replay) Next Gen Visualizations in Power BI - with Gopal

ABSTRACT 📄

1. Deliver Advanced Visualizations with Data Stories in no-code user experience in just few clicks.

2. How Inforiver Charts is helping Tableau, Qlik and Tibco Spotfire customers to migrate to Power BI by offering change management with coverage to missing features and functionalities.

3. We will focus on demonstrating unique features on why Inforiver Charts over Deneb or Native Power BI Visuals.

4. Buying Direct with Microsoft - Inforiver Charts and/or other Transactable Custom Visuals 5. Inforiver Charts Pricing Model.

5. What’s the roadmap for Inforiver Charts.

RELATED CONTENT 🔗

InfoRiver Charts
Inforiver Charts AppSource
Lumel

New Relationship Pane Walkthrough for Power BI Desktop

Video by: Reid Havens

Let's review the NEW relationship Pane (in preview as of February 2023) that can be found in the Model View for Power BI Desktop! We'll compare it to the traditional relationship pop up window as well! Tune in to learn more.