Power BI

Here’s a twist on dynamically filtering visuals by a slicer in Power BI! You can’t use a measure directly in a slicer, so here’s a way to get a similar experience and maintain usability of your reports. Scott Sewell: https://twitter.com/scottsewell BI Elite Video: https://www.youtube.com/watch?v=AZAL-QPn5Zc

Join the Power BI team and be inspired by community experts, learn best practices, and discover helpful resources with other attendees.

Title of the document

Microsoft has partnered with Wolfram to provide new data types, and we are excited to announce their availability for all Microsoft 365 Family and Personal subscribers in English! Getting reliable data from trusted online data sources into your Excel workbook on subjects like cities, foods, animals,...

Learn about Step Folding Indicators and Query Plan features for Power Query Online!

A video on how to make Power BI refreshes faster

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

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

On-premises data gateway (standard and personal mode) release for May 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.