Power BI

Here is how to create a jitter chart in Power BI with averages by categories and using only Power BI and DAX capabilities.

Helpful intro for Windowing Functions

Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. This whitepaper is a draft.

Welcome to the January 2023 updates on Power BI Datamarts. This month, we’ve added a variety of new features based on your votes on ideas.powerbi.com. There’s more to explore, as well as a sneak peek of what’s coming soon, so please read on!

No Premium - no problem! What do you do if client asks for performance optimization, and there are no premium features available? You improvize and win!

This blog post shows how to setup and configure Power BI Premium/Premium Per User datasets to be backed up.

Allow end users to pass any value they want to a dynamic M parameter in a Power BI DirectQuery dataset

Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Reports for Power BI and Dataverse. - GitHub - mscottsewell/Power-BI-D365-Sales: Power BI ❤️ Dynamics 365 CE Sales! (beta) Template Sales Re...

Contribute to PBIQueryous/Deneb development by creating an account on GitHub.

Deneb-Vega data visualization examples. Contribute to avatorl/Deneb-Vega development by creating an account on GitHub.

Development examples of Deneb visuals created by David

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub.

There’s only one rule. Don’t break the fold! Before we start enforcing all these rules, we should start with something like a solid foundation of what does and doesn’t fold in Power Query and their SQL equivalents. Now, if you found this page and we’re like “what in the world is query folding?” read this […]

Are you interested in learning Power BI, but want to do it outside of your corporate environment? We’ve got great news for you! You can sign-up for the Microsoft 365 Developer Program entirel…

null

Get up to speed with PowerShell Hashtable: a powerful data structure for storing key-value pairs. Learn the basics and gain insights into advanced features.

DataOps Principle #3: Embrace Change

ABSTRACT 📄 Do you know your data? Do you have confidence in the data of your Power BI solutions, no matter what? And do you already actively monitor for deviations from those expectations? Being in control of your data (quality) is essential for any solution, and it can be quite difficult to achie

Performance tuning is usually a complex and iterative process. This article provides an insight on the most common scenarios and how to leverage various concepts and techniques to optimize the performance of Power BI solutions

My post on which languages to learn as a Power BI developer resonated with many people so I thought I'd take a step back and write about how to navigate the various facets of the business intelligence job market. Where language selection is effectively a tactical tool choice, in this entry we'll focus on the

It's LIVE! Are you dreaming of advancing your career by getting the most in-demand certificate? This course walks you through each and every topic necessary to master the skills required for the DP-500 exam (Azure Enterprise Data Analyst)

Implementing Data Contracts for Entities

Learn how to create a Custom Page Dialog for Model-Driven Apps with this Task Generator example. Generate consistent Tasks but the user decide which will be generated!

Learn about the Power BI modules and Cmdlets for Power Shell, why using it, and examples of using these in real world scenarios.

DAX is more than the name of my new puppy

This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Finding errors in DAX

It just got easier to create multi-language reports for Power BI.