Posts filed under Topics & Discussion

(Livestream Replay) Why Power BI Community Rocks! - with Nikola Ilic

When you're learning a new technology or upskilling in a specific tool, chances are that you'll need to connect with your peers that are trying to achieve the same, or already went through this path. In this live stream, we will talk about one of the most vibrant technical communities, the Power BI community, and how joining it may help you not just to master specific concepts, but also give you a career boost and new opportunities.

GUEST BIO 👤

I'm making music from the data! PowerBI consultant and trainer, Microsoft Data Platform MVP, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!

RELATED CONTENT 🔗

Nikola's Website
Nikola's Twitter

Posted on March 25, 2022 and filed under Livestreams, Topics & Discussion.

(Livestream Replay) Microsoft HATES Greg Deckler!

Come see a demonstration and learn about the first Power BI external tool to extend Power BI Desktop’s Quick Measure functionality, Microsoft Hates Greg’s Quick Measures (MSHGQM), with it’s author Greg Deckler, the king of Community.PowerBI.com’s Quick Measure Gallery. With over 120 built-in quick measures and the ability to easily add your own custom quick measures, MSHGQM can help create simple to complex DAX expressions more quickly and easily than ever before!

GUEST BIO 👤

Greg Deckler is a Vice President at Fusion Alliance and has been a professional technology consultant for over 27 years. Greg is a six-time Microsoft MVP for Data Platform and an active member of the Power BI Community site with over 5,000 solutions authored and almost 200 Quick Measure Gallery submissions. Greg has authored 4 books on Power BI and is working on his fifth.

RELATED CONTENT 🔗

MSHGQM GitHub Repository
Microsoft Hates Greg YouTube Channel
Greg's Twitter
Greg's LinkedIn

Posted on March 25, 2022 and filed under Livestreams, Topics & Discussion, External Tools, DAX.

(Livestream Replay) Visual Formulas Vs DAX - Making a Case for InfoRiver - with Marco Russo as Moderator

Power BI has recently done a dedicated blog on Inforiver to highlight a new set of capabilities. So the owner of Lumel Visuals Gopal is going to discuss and debate the new architecture approach adopted by Inforiver. Marco Russo will also be a moderator in the livestream, as he’s advocated for visual level calculations with his SQLBI blog, and Inforiver delivers these new capabilities to Power BI.

Join us as we use our unique industry backgrounds to provide perspectives on how InfoRiver can be a smooth transition for Excel users to Power BI using a no-code visual-level calculation user-experience. We will also discuss how developers and business end-users can benefit from specific features such as: Visual Formulas, Excel like Formatting, Commenting, Planning, Paginated Reports, and Write-Back capabilities.

RELATED CONTENT 🔗

Microsoft InfoRiver Blog Post
InfoRiver
Lumel

SQLBI Visual Formulas Post
SQLBI
Marco's Twitter

Posted on March 25, 2022 and filed under Livestreams, Topics & Discussion, Power BI, Visualizations.

Tabular Editor 3: [DAX] Debugger Walkthrough in Tabular Editor 3! - with Daniel Otykier

It is no secret that DAX is a relatively complex language which is difficult to master. Most data model developers have probably experienced a situation, where the DAX code did not return the expected result. In this situation, it is helpful to break down the code, variable by variable and function call by function call, to better understand what is going on.

Until now, this "breakdown" of the code was a tedious and time consuming task, which often involved capturing DAX queries executed by client tools, in order to break them down and execute smaller pieces of the queries in DAX Studio or SQL Server Management Studio.

Tabular Editor 3 introduces the concept of the DAX debugger, which is a tool that makes the process of stepping into the DAX code of your model, much, much easier! At a conceptual level, the debugger is similar to traditional IDE debuggers, such as the one found in Visual Studio when developing C# applications.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool.

RELATED CONTENT 🔗

DAX Debugger
Tabular Editor 3
Daniel's LinkedIn
Daniel's Twitter