Introduction If you know much about me from this community, you probably know that I love the Quick Measures Gallery. The Quick Measures Gallery is one of those things that I latched on to because […]
There are many reasons you might need to combine multiple queries into one appended table, and the Power BI Get Data From Folder makes this process much easier for many data sources. However, it has […]
Here is the August 2024 release of the on-premises data gateway (version 3000.234.5). Power BI Desktop Compatibility This update brings the on-premises data gateway up to date with the August 2024 release of Power BI […]
For demonstration purposes, I have created two sample tables. Sales Role Below is the Power Query for both tables. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“hZVBTsMwEEWvgroukmfsOPYFWLBFrEoXEXTBpkKQ+6shjeMf8ydUldpK7yeemTfp6XRw8ji91Uk+HA+v18/x8vHwMg7j5Wf6LZ2bXtOXPH+ej3debd4vvCLvbT4ufEA+2Hxe+Ih8Z/KhnCchH01e+zsvblNwbwZESmBTcbIDWgKbkrMd8CXgtQbE2YGwHilAwB7yPOU5IBEC9pQlrl1KUMPvHdTRAG+r2oG0zC1r45HBFy9SaDzivBav+9h4ZPBSvGsLnjv0Nj4PX8MVDTI2BsiijrErSOruliDpd/cDyX53M5BM+zuBaN7fBuyTYzVlRgqpqfqPtw+kJmFTqspjTULHFGlNq+ykp81uK0G79aqeGo5obSqVG9CwPiuEek08JTu8dODpe7i+XzZWWU4DWrSypAY0MQMCRTMZLGpd0eJVY2ukl43ssP1eXbbZleV/apmi7P8M3f6nB0LnxXsgdGBKn0JgN5wgsLqUoh17DnmGdnS2gaFVb9d68Idt/T7fAA==”, BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta […]
This week, we revisit creating multiple ToolTips for one visual. Since the Power BI interface has been undergoing some transformations, we aim to provide a clear route to access this functionality. ToolTips are speech bubbles […]
Welcome to the August 2024 update. Here are a few, select highlights of the many we have for Power BI. You can now ask Copilot questions against your semantic model. Updated Save and Upload to […]
For a beginner in Power BI and in business intelligence in general, it is not easy to understand data types and differentiate them from data format. And then comes data category… So, what’s all that […]
Downloading Scanner API data using a Microsoft Fabric Notebook I was recently working with a customer where they had more then 100 app workspaces and I was running into some challenges when using the Scanner […]
Introduction There are some common issues/problems that many Power BI users will encounter at some point or another during their course of using Power BI. In this blog article, I attempt to catalog the most […]
Handling relationships is an essential aspect of any data modeling exercise. If done correctly, it can save a lot of time and effort. Power BI offers many-to-many relationships, but at times it adds many complexities. […]
© Copyright 2023 QuantInsightsNetwork