Power BI

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

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.

Data Source management enhancements on Power Platform admin center

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. The end result in this scenario is a report where the user has selected a date with

A lot has changed since we first released the preview of the small multiples feature — let’s take a look at what we’ve shipped since then, discuss updates to our roadmap, and explore opportunities to provide feedback.

It’s just over a week after MBAS. The storm has quieted down, and life is back to normal. This can only mean one thing – it’s time for this month’s update! Next to all the things we covered at MBAS there are more things happening, including a new preview of visual tooltips. Next to that, you can now quickly create reports from SharePoint lists and sensitivity labels are not inherited downstream. There is so much more in this update, so read on!

There were a lot of exciting announcements at the Microsoft Business Applications Summit this week but if you only watched the keynotes or read the recap on the Power BI blog you will have missed a…

How to build a process using Visual Studio Code that allows you to visualise and analyse a Power BI dataset refresh in real-time.

Power BI Goals help you visualize and monitor your business’ statistics, analytics, and metrics (SAM) over time. I'll show you how to...

XMLA endpoints in Power BI supports out-of-line (OOL) bindings, an advanced Analysis Services capability to temporarily change the data bindings of certain metadata objects in a dataset for the duration of a refresh command, such as data sources, partitions, and expressions.

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. When you apply a filter in CALCULATE or CALCULATETABLE, by default the filter overwrites any existing filter over the columns specified in the filter. In order to avoi

Business analytics refers to the digital analysis of data from a range of sources, giving organizations the information they need to make informed decisions rather than relying on guesswork. This …

When you use a parameter as the url in a web query, the data source is a Dynamic Data Source and will not refresh in the Power BI service.