Power BI

Sum the visible values of a table in Power BI

Following on from my last post, another SQLBits session of mine I wanted to highlight was “Advanced Analytics Features In Power BI”. The subject is a bit outside my normal area of exper…

Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure

How to display the distribution of the distance between transactions in a column chart? Let’s see how to implement a complex calculation splitting a c

Going forward, there will be two major changes to the Power BI Deployment & Governance training course. Video content will be consumed by participants on-demand Group Q&A sessions, will be held independently, will be live at multiple times to accommodate global time zones

This Solution allowed me to create and manage a course running to nearly 300 lessons. It's special because without the Power Platform and Dataverse I couldn't have made it at all.                                                 Last year I missed the boat for getting an entry into the extravaganza. ...

Table check box

How Microsoft’s Digital Transformation Group is Tracking and Reviewing Health Metrics using Microsoft Power Platform and Dynamics 365.

How to get the Microsot Teams context and theme and make your Power Apps canvas app look like a native Teams app.

A walk through on how to build a measure in Power BI that lets you group and count the last known state for a given set of items

Inforiver delivers the best of both worlds – spreadsheets & standardized BI reporting and visualizations – through a low-code / no-code architecture that drives excellent authoring, consumer & collaboration experiences for unrivaled analysis productivity and ROI.

An introduction to deployment pipelines the Power BI Application lifecycle management (ALM) tool

Mike Allen's Blog - Doing Smarter Things With IT - I’m going to show you how to calculate primes in Excel using Power Query and the Sieve of Erat

The new Show Azure Active Directory guests in lists of suggested people setting in Power BI Admin Tenant Settings helps organizations choose how easily users can share with external users.

On-premises data gateway (standard and personal mode) release for May 2021

PCF Form Json Sample JSON Form string Sample JSON Result Solutions How to InstallPCF Form JsonA PCF Component that receives a predefined JSON format string and displays it as a Bootstrap Form. Then, …

“Demo Extravaganza” is an incredibly fun community event where the contributors submits samples, community votes on which samples they want to see more of and have the top three authors show how their sample were built, best practices employed and challenges they overcame! If you want to participate here are the key dates! Entries start – May 10th Finalist voting starts – June 1st Finalist voting ends – June 30th Application Finals / Winner Announced – July 21st Component Finals demonstrate -August 18th

We are excited to announce that Microsoft Power Apps has been recognized as a Leader in The Forrester Wave for Application Development and Delivery Professionals, Q2 2021.

Documenting Power BI - How to create documentation for your Power BI data model with simple steps. - Mihaly Kavasi - Self-Service Business Intelligence Blog

Working with large data volumes in Power BI desktop can be tricky if you don’t have a high spec machine. When you are using Import mode to create models in Power BI desktop, it loads all the …

AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in Read more about How to use AddColumns function in DAX and Power BI[…]

We’ve mentioned them multiple times but now to bring them all together. These are the TOOLS you need to take Power BI to the NEXT LEVEL! Tools we use every day! Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer External tools in Power BI Desktop https://docs.microsoft.com/power-bi/transform-model/desktop-external-tools DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ ALM Toolkit: http://alm-toolkit.com/ Guidance […]

Creating a Query catalog of a Power BI workspace, using read-access XMLA endpoints. and a C# Azure Function.

This is an an "unboxing" post on Power BI Goals so that you get a quick look at the major parts of the feature.

Each year, Gartner invite vendors from the BI and Analytics Magic Quadrant to show how their product can help solve real-world problems and find insights in real-world data. In previous years we’ve looked into the opioid crisis in the USA, global happiness, and life expectancy. This year the impact of COVID-19 was the obvious candidate! There is a wealth of data available on the internet, and while Gartner gave us some direction for the business questions we would investigate, we could use data from any number of sources to do the analysis. In this blog post you can see what we built and we will explain how we built it.