Field notes, deep dives, and licensing breakdowns from twenty years of building on Power BI, Fabric, and Azure analytics.
ALM Toolkit is a free and open source tool that facilitates the deployment of Microsoft Power BI datasets, detects differences between source and target datasets, checking for changes to be deployed to help ensure the integrity of the target model. For datasets with incremental refresh policy applied, you must avoid publishing and replacing them with…
This last article includes a list of best practices for data visualization. – Use filters in your visualizations to reduce the amount of data that display: The more data a visual must display, the slower it will load, so apply filters in the Filters pane, or use Top N, to reduce the number of items…
In this post I’ll show you several tools that can help you analyze the performance of your Power BI solutions at every step of the way, some of them are built-in features and others are free and open source. In this checklist you will find the tools you can use at every step of the…
This second article is focused on best practices for designing your data model, optimizing CPU, RAM, and workspace capacity consumption by minimizing memory usage. Benefits. Reduce space and processing time. Faster refresh times. Lower latency reports. Reduce the time development. More user-friendly data models because the user will not navigate through a bunch of useless…
[vc_row][vc_column][vc_column_text css=”.vc_custom_1663800743577{margin-bottom: 0px !important;}”] What a great first day of the Microsoft Power Platform Conference 2022. A wonderful day full of great speakers! Here’s a brief summary of some of the sessions I attended: What are Power BI Metrics? – By Treb Gatte In this session Treb talked about the Power BI metrics and how…
[vc_row][vc_column][vc_column_text css=”.vc_custom_1664321719850{margin-bottom: 0px !important;}”]Last week was the first Microsoft Power Platform conference with over 150 interesting sessions and 18 workshops, I had the pleasure of meeting new people who share my passion for Power BI, and I met some of the heroes I’ve been following and learning a lot from like Patrick, Adam and Miri…
This third article will cover how to optimize the DAX Formulas of your data model – Convert Multiple Measures to Variables: This will minimize the number of measures on your data model and improve their performance. – Use the DIVIDE function for division instead divide operator (/): This function is optimized to check division by…
Query Folding is the capability of Power Query to delegate some of the transformations to the source to improve performance. In this post you will see its importance and good practices guide to achieve it. According to official documentation the following data sources support query folding: – Relational databases (SQL Server, Oracle, etc.). -OData sources (including…
This is a series of articles about the most important practices at every step of your solution to get scalable data models and faster reports: At the end of this series of articles, you will be able to download the summary checklist in Excel format, I recommend you keep it handy to review it every…
Is your data model turning into an unfriendly monster full of unnecessary columns and measures with long refresh time? Or after cleaning up your data model, do you find that connected reports break so you manually go through each one to find the cause? In this post I will introduce you to the first version…
I have been preparing for several weeks to take the DP-500 exam and thought I would like to share with you the resources I am using. This is the second exam that includes Power BI and in this article you will find the comparison between it and the PL-300 Exam, the skills required, study resources…