Power BI

In this post we'll have a look at 3 complex cases where DAX proves to be a more efficient tool than Excel.

The conclusion of the blog series looking at migrating from AAS to PPU and how it can be done in Power BI.

Learn how to easily export metadata of visuals, filters and other objects within your Power BI report.

You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – whi…

Thanks to everyone that attended the MN BI User Group meeting today. Here is a link to my slides that I presented and if you have any questions about the content please feel free to reach out here,…

The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! After months of recording and post-production wo

You can now analyze which measures and columns are used where in reports that are connected to Analysis Services models as well.

In this Power Bi tutorial, let us learned how to use Power BI Pyramid chart, and the below points:Complete SharePoint Training Course Just for $199 (Just for Today)Power Bi pyramid chart download• How …

Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix.

Introduction Have you ever wanted to add a toggle feature to your Power BI Desktop Report, but don’t know how? Well the good news – it is easy to do, and even better news I will show you how to 🙂  A quick background – A toggle switch was made so users could see if […]

Here is how to calculate a moving average or sum in Power BI by using DAX. Sometimes moving average is called running or rolling average.

Here is how to detect the last available column value in Power BI in almost any situation. The problem is columns with missing values.

Here is how to create a Power BI line chart that at some point continues in a different design, formatting in few easy steps.

#APIS #CATALOG #POWER BI #POWER BI ADMIN API

Time flies when you are having fun and learning, right? Time for the 6th blog in the series of transforming a local solution into a global, enterprise-grade Power BI solution. This episode will be …

CSG ProCustom Software, Business Intelligence and Cloud ServicesBasic Power BI ReportThe Very Basics of Great Power BI Report DesignSome Power BI report design skills take years to master. These …

Here is how to create a dynamic histogram in Power BI. It changes with the help of a slicer that regulates data distribution groups (adjustable bins).Forewords about histogramA histogram is a great …

This is not the first time I have shared this concept.  In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]Read More »

Today, Forrester has recognized Microsoft as the Leader in both strategy and current offering in The Forrester Wave: Augmented BI Platforms, Q3 2021.

Frustrated that a you can only do a full refresh? Patrick takes it to the next level by showing how you can refresh only a single table in your Power BI dataset. This is a great option for targeted refresh and avoid potential overhead. Processing Options: https://docs.microsoft.com/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services?view=asallproducts-allversions Refresh Types: https://docs.microsoft.com/azure/analysis-services/analysis-services-async-refresh Elegant BI Blog: https://www.elegantbi.com/post/datarefreshintabulareditor https://www.elegantbi.com/post/processingmanager

This article reviews Data Governance Initiatives to determine how to secure data usage, manage activity, gain visibility, and control of one of your most important assets.  Whether on-premises or in the cloud, more employees are using and sharing an ever-increasing amount of data throughout your organization.

Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance an

Power BI Push Tools is a set of open-source tools to work with Power BI push datasets. Read Implementing real-time updates in Power BI using push datasets i

Download your Free Power BI resources

Tables in your Power BI reports don't need to be old-fashioned boring visuals. Check how you can create astonishing tables for your users!

Have you ever been faced with the issue where Power BI automatically adds a sigma symbol to the front of your column if it detects it’s a data type of integer or decimal? Now this isn’t too much of an issue if you’ve imported only a few columns but what if you’ve imported lots? Going […]

Video by: Reid Havens Learn a unique way to utilize a waterfall by restricting its categorical comparison to just two values , with a breakdown comparison between. By combining a slicer and a bit of DAX magic in Power BI.