From the blog

Power BI and Fabric, field-tested.

Practical posts and videos on Power BI, Microsoft Fabric, Inforiver, DAX, notebooks and AI.

Revolutionize Date Filters in Power BI with Super Filter!Data filtering is a cornerstone of building dynamic, user-friendly Power BI dashboards. But what if there was a tool that could revolutionize how you manage date filters? Enter Super Filter —a…Super Filter: The Ultimate Slicer Upgrade for Power BI!Discover the Super Filter , the latest custom visual for Power BI that's packed with powerful features! 🌟Master Incremental Refresh in Dataflow Gen2Struggling with lengthy data refreshes? Incremental Refresh in Dataflow Gen2 is the game-changer you need! 🚀Is Deployment Pipeline Ready for Prime Time ?In my latest video, I explore the current state of deployment pipelines in Microsoft Fabric, covering everything from setup and customization to the pros, cons, and recent updates.Enhancing Collaboration in Power BI with Advanced Commenting FeaturesPower BI provides the basic ability to add comments at the report and visual level, which supports collaboration by enabling users to:Transform Excel report to Pro-Level Dashboards: Inforiver visual!!!We have all worked with Excel reports which have a complex layout, with measures at different grain in the same report. How do we convert these reports to Power BI. I present a few options in this…Fix SQL Analytics Endpoint Sync Issues in Microsoft Fabric – Data Not Showing? Here's the Solution!If you’ve ever written data to your Lakehouse in Microsoft Fabric, only to find it missing when querying through the SQL Analytics Endpoint—don’t worry, you’re not alone! 😬Search functionality using Apply AllDid you know that you can use the Apply All button to create a search functionality in Power BI? The Apply All Slicers and Clear All Slicers features not only enhance report performance but also…All you need to know about Page Navigation in #powerbiPower BI has introduced several ways to implement page navigation, each with its own benefits and challenges. In this video, we’ll explore three different methods of page navigation and their use…Top 5 Notebook Hacks in Microsoft Fabric for Databricks DevelopersMaking the leap from Databricks to Microsoft Fabric? As exciting as it is, you’ve probably noticed a few things don’t work quite the way you’re used to. Instead of getting stuck, I’m here to help…Fabric AI Skills has just been released, but does it already run circles around Power BI Copilot?Answers are in this video: 🎥👇New Course Alert: Time Series Forecasting in Power BI!I'm excited to announce that our latest course on Time Series Forecasting using DAX in Power BI is now live!Editing Delta Tables in Microsoft Fabric Using NotebooksIn this video, I’ll walk you through how to edit Delta tables in Microsoft Fabric using Notebooks. We’ll cover adding columns, inserting and updating rows, and creating views. Let’s dive in!Best Master Data Management in Power BI and Microsoft FabricWelcome to an exciting new capability in Power BI and Microsoft Fabric – Editable, brought to you by Inforiver and Lumel!Is Copilot in Power BI getting better ?About a month ago, Power BI team released updates to Copilot in Power BI. With this update Copilot can answer questions against the semantic model. Let's give this a try and see firsthand how much…DAX Calculation for Time Series Forecast - Part 2Updated: If your are looking for the Power BI Desktop file with all the logic in it, please go this page: https://www.obvience.com/time-series-forecastingCreate a Powerful Forecast Template in Power BI with Inforiver VisualWelcome to the in-depth tutorial on using the Inforiver visual in Power BI to create an advanced forecast template! This video will guide you step-by-step through the process of setting up a…DAX Calculation for Time Series ForecastUpdated : If your are looking for the Power BI Desktop file with all the logic in it, please go this page: https://www.obvience.com/time-series-forecastingEnterprise Grade RAG in #Microsoft #Fabric using #CosmosDB and #DiskANNIn this video, we’re hardening our RAG architecture to meet the demands of the enterprise! Building on our previous video (https://youtu.be/jwVOQCUUH1Y), we are making our RAG for Microsoft Fabric…Step-by-Step Guide to the Best Planning and Forecasting Visual in Power BIThis is a comprehensive guide to configure the best planning and forecasting visual in Power BI - Inforiver! In this video, I will walk you through the steps to set up and optimize the Inforiver…Inforiver - A No-Code Planning, Forecasting and Writeback visualUnlock the full potential of Power BI with the revolutionary no-code solution! In this video, we explore the key features that make Inforiver a game-changer: No Code Solution: Simplify your…Promotion Effectiveness and Category ManagementSTILL promoting your products at a loss?!? Time to put #PowerBI to work and find out how to #getsmarter with your #data . I introduce the basics of Promotion Effectiveness and Category Management…Are you sure you are using Direct Lake connection ? Here is how to validateThe key differences between Direct Lake and Direct Query modesRole-Based Data Access for OneLake in Fabric | Step-by-Step TutorialIn this video, we'll guide you through the entire process of setting up role-based security for your data in OneLake. Whether you're a beginner or looking to refine your skills, this tutorial will…Forecasting with LLM and GenAI in Microsoft FabricToday, we're tackling a topic you probably haven't seen before: how to forecast and make predictions in Microsoft Fabric using Generative AI and Large Language Models (LLMs).Implement #RAG (Retrieval Augmented Generation) with #langchain #chroma #OpenAI #MicrosoftFabricIn this video, we’re taking our RAG architecture to intergalactic levels! Building on our previous video (https://youtu.be/oCHinlZRsLU), we’re removing dependencies on PaaS components like…Understanding the Costs of Fabric DW Queries: A Deep DiveWelcome to our deep dive into Microsoft Fabric! If you're navigating the complexities of Microsoft Fabric, one critical aspect you'll want to master is understanding the cost of each activity,…How to create a stacked chart with Better or Worse indicatorsvery inch of your dashboard real estate is precious. That’s why it has to be packed with as much insight as possible. I almost never use stacked charts because they don't make it easy to add…Choosing the Right Data Ingestion Method with Microsoft FabricMicrosoft Fabric provides various options for data ingestion, each with its own strengths and use cases. Understanding which option to use and when can significantly impact your data workflow…Exploring Copilot's Role in Dataflow: A Dive into its FunctionalityIn the realm of Power BI Dataflow, we're accustomed to the richness of functionality and the ease with which these functionalities can transform data. But what about Copilot? Can it help us…How to remove blanks and repeats form tables and charts in parent child hierarchies #powerbi #daxShould core PowerBI visuals natively support Parent Child hierarchies? Yes... do they? No... We have to deal with blanks and repeats and all kinds of things to make our charts and tables look…Copilot in Power BI Desktop - what does good look like? #powerbi #copilot #msfabric #reviewWho is going to win in the upcoming AI vendors showdown? My guess is it will be whoever can figure out how to make AI understand the intricacies of various business domains, like sales and supply…What is FAST COPY and do you really need it ?Fast Copy provides the ability to ingest data at scale. In this video I try to answer:Data Mirroring - Real-Time data replicationWe have all heard of Real-Time solutions before. But each of them come with challenges. Either configuration is complicated or involves coding/ETL or the cost is exorbitant.Price Volume Cost Mix analysis for Gross Margin!So excited for this video, hundreds of hours of work are finally coming together!Performance Flow by xVIZ is the best visual for Parent Child hierarchies In Power BIThis video is taking a look into how XViz’s Performance Flow visual enhances Power BI’s ability to manage and visualize parent-child hierarchies. We’ll start with an introduction to Performance…LangChain Agents to query Power BI datasets in Microsoft FabricThe realm of Business Intelligence (BI) stands on the brink of a revolution, one that promises to redefine our understanding and management of data. At obvience.com, we’re no strangers to the…How to implement RAG in Microsoft FabricIn the previous posts we were starting our journey with Azure OpenAI and Microsoft Fabric for Data Engineering and Business Intelligence use cases. In this video we are kicking things up a notch…How to generate Business Friendly #PowerBI Data Dictionary using #OpenAI #SemanticLink #msfabricIn this video I will continue to explore how we can incorporate Azure OpenAI, LLM, GenAI, not even sure what right buzz words to use here 🙂 , in the world of Business Intelligence and Microsoft…Data Enrichment with OpenAI in FabricI've just put together a video that I'm really excited about. It's about using Azure OpenAI to make your data work smarter, not harder. If you've been curious about how big language models (like…Getting Started with Notebooks in Microsoft FabricMaster Azure Notebooks for Lakehouse Data ManagementPower BI Copilot In Action: Enhancing Analytics with AI?Is it too early to start a meaningful conversation about hashtag#Microsoft hashtag#Copilot for hashtag#PowerBi ? Check out this detailed review video with some insightful food for thought at the…Unlocking the Power of Microsoft Fabric: Data Ingestion with Lakehouse & Data Flow Gen2 Explained!Jump right into what's new with Microsoft Fabric since it hit the scene in November 2023! Nikil's here to walk you through what's been added and updated, with a big focus on making sense of data…Streak AnalysisTracking metrics like impressions, engagements, and conversions gives us a broad overview of our campaign's performance. However, this approach misses out on understanding the engagement patterns,…