Power BI

Do you often have to draw up diagrams of data flows or data architectures and would you like to use Microsoft Fabric icons in your diagrams? Then this post is for you! I always found it hard to find the right icons I needed, so I’ve put them all on this single page for easy access, both as PNG and SVG.

Learn how to leverage VertiPaq Analyzer tool to get a quick and convenient insight into your Power BI data model structure!

The Mastering DAX Workshop is the most advanced course available on the DAX query language, bringing our students to a whole new level of expertise.

The new version of the Power BI Cleaner tool prevents you from deleting DAX expressions that have been used in calculation groups.

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX…

The next chapter in this series on Creative Aggs looks at Filtered Aggs, what they are, and how you might use them to speed up reports connected to Power BI and SSAS models. The series so far : Int…

Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.

Patrick looks at how you can use DAX Studio, or SQL Profiler, to do query profiling on Power BI Premium. This can help you debug query performance and more.

Export data from visuals in Power BI has limitations that can be circumvented by a simple trick. Using DAX Studio with a automatically created query:

Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me [...]

Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can …

Patrick walks you through how you can use Power BI to build a custom KPI scorecard. The key is the UNICHAR DAX function. Demo files: https://guyinacu.be/demofiles

Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Re…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup134 2 Minute Tuesday: https://guyinacu.be/databrickserror Patrick’s tech video: https://guyinacu.be/modelview Adam’s tech video: https://guyinacu.be/powerbigetdata Sources DAX 101: Summing values for the total (@FerrariAlberto) Power Query Memory Usage, Dataflow Container Size And Refresh Performance (@cwebb_bi) Creating a Fiscal Saturday Calendar (@kpuls) Governance settings for Power […]

This post explains how to use Power BI DAX measures in an efficient way, when there are multiple disconnected slicers that you want to use.

In this blog post, I am showing how to export all data from a Power BI file to CSV files or SQL Server tables.

I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX! A general overview of the process to accomplish this task is as follows: Create a slicer. Create a

Welcome to post number 6 in my series concerning Microsoft Exam 70-778. The series aims to provide a revision tool for those who are looking at taking the exam and to also provide an introduction i…

Fun with DAX – A-Maze-ing DAX (@PhilSeamark) 24 Days of PowerPlatform – Day 1 – Let’s kick it off.. (@wstrasser) Power BI Fast and Furious with Aggregations (@Rad_Reza) Power BI Dataflows and Slow Dat…

Makeover Monday this week focused on a variation of the “Big Mac Index”, where costs for various activities are compared in different cities. The original article presented data in a st…

In this article, we will see how to combine different dimensions and facts inside a single matrix table visual.This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside the column. The previous would be impossible without this technique....

Switching a report from one PowerBI dataset to another PowerBI dataset (@donsvensen) Get data from PDF in Power BI (@CurbalEN) Using Dax To Handle Multiple Parent Hierarchies (@PowerPivotPro) DAX Guid…

Why I changed my mind about #PowerApps and became a fan… and why you should, too (@jenstirrup) Optimizing DAX with cardinality estimation (@marcorus) Announcing Dashboard Comments in Power BI: Your new hub to discuss data and collaborate with others Power BI Service and Mobile July & August Feature Summary Power BI Desktop September 2018 Feature […]

In this video, Patrick talks about Power BI Desktop and role-playing dimensions. Can you even do this in Power BI Desktop? Patrick shows you why one particular way is not recommended as it will cause trouble. And then show you how you can use DAX within Power BI Desktop to take this to the next […]

PowerBI.Tips and Phil Seamark are proud to release our third game written in Power BI, DAX Mission Impossible. This game is similar to the game [...]

DAX Studio connects to a Power BI Desktop model using a technique that was not officially supported until a few months ago. This changed when the “diagnos

This Power BI report provides the DAX reference \ Cheat sheet. This report extracts the data from the Dax references from the below MSDN link. The Web Data source and Add tables using using Examples h…

Keyboard shortcuts is an interesting topic for developes that can really improve your report development in Power BI Desktop. In this post I show you some keyboard shortcuts/hotkeys when writing DAX in Power BI Desktop. Indend right: Ctrl + ] Indent left: Ctrl + [ Mini-tip: You can also indent your code to ther … Continue reading Quick Tips: Keyboard Shortcuts/Hotkeys When Writing DAX in Power BI Desktop

Column-based calculations are part of every BI project. Some of the most common examples include building a street address column from individual fields, concatenating a person’s full …

Fun with DAX – Sudoku (@PhilSeamark) Custom Web Fonts and Icons in Power BI (@dataveld) POWER BI REPORT SERVER DEVOPS (Trisha McCormick) Automatically expand all fields from a JSON document in Power BI and Power Query (@TheBIccountant) Correct calculate of age in DAX from birthday (@marcorus) BONUS ITEMS: Segmented Filtering with Slicers (@PowerBITips) More Details […]