power bi desktop
414 TopicsHybrid Tables in Power BI | Shabnam Watson
Hybrid Tables in Power BI Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time! Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BIโs memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system. Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery). Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Shabnam Watson: Shabnam Watson is a Business Intelligence consultant and Microsoft Data Platform MVP with 20 years of experience developing Data Warehouse and Business Intelligence solutions. She has worked across several industries including Supply Chain, Finance, Retail, Insurance, and Health Care. Her areas of interest include Power BI, Analysis Services, Performance Tuning, PowerShell, DevOps, Azure, Natural Language Processing, and AI. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI. She is a regular speaker and volunteer at national and local user groups and conferences. She holds a bachelorโs degree in Computer Engineering, a masterโs degree in Computer Science, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI). This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Shabnam: LinkedIn: https://www.linkedin.com/in/shabnamwatson/ www: https://shabnamwatson.wpcomstaging.com/ Twitter: shbwatson Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.1.3KViews0likes0CommentsPython For Power BI Developers
As a Power BI developer you write DAX, M but should you learn Python as well? While there are limited use cases for using Python directly in Power BI, in this session Sandeep will show you how you can use Power BI in your development workflow. He will show how you use can use Python for analyzing Power BI datasets, debug DAX, find insights faster, and even for Power BI administration. As lakehouse architecture patterns become common you should strongly consider adding Python to your tool chest. Sandeep will also share resources to learn Python for data analysis. **No prior Python experience is required to attend this session. ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: English304Views0likes0CommentsDAXdakan ep4: PBI Desktop Nov 2023 Update
As requested, let's discuss the November 2023 update of Power BI. Button slicers and Copilot! DAXdakan is a fortnightly Teams meeting with other Power BI-erists (Power BI Pilipinas members). Language is Filipino/English. Attendance is free.221Views0likes0CommentsCOUNT vs COUNTA vs COUNTX in Power BI DAX | Aggregation Functions | Episode 2
In this episode, we take a deep dive into three essential DAX counting functions: โ COUNT() โ COUNTA() โ COUNTX() Using multiple practical examples and real-world business scenarios, you'll learn ๐น How COUNT(), COUNTA(), and COUNTX() work in Power BI DAX ๐น The key differences between these three functions ๐น When to use each function in real-world reporting scenarios ๐น Step-by-step demonstrations with practical datasets ๐น Best practices to write efficient and accurate DAX formulas watch?v=i3hSzbTYcFQ227Views8likes3CommentsAVERAGE, AVERAGEA & AVERAGEX in Power BI DAX | Aggregation Functions Episode 1
In this video, we begin our new playlist dedicated to mastering DAX Aggregation Functions in Power BI. First, we explore all the aggregation functions available in DAX and then deep dive into three important functions: โ AVERAGE() โ AVERAGEA() โ AVERAGEX() watch?v=Om-M_qU03dY?si=VmUZ7q2DU21_gyNT321Views8likes5CommentsPower BI DAX Financial Functions Explained | YIELD, YIELDDISC & YIELDMAT with Examples
In this video, we explore three important Financial DAX Functions used in bond and investment analysis: โ YIELD โ YIELDDISC โ YIELDMAT Subscribe for more Power BI, DAX, SQL, Microsoft Fabric, and Data Analytics content. watch?v=UBsXBzkYUcA?si=glupoEmS8SZvhZS5210Views8likes5CommentsPower BI DAX Financial Functions Explained | RATE, INTRATE & RECEIVED
In this video, you'll learn three important Financial DAX Functions in Power BI with practical business examples and step-by-step demonstrations. โ RATE Function โ Calculate interest rates for loans and annuities โ INTRATE Function โ Determine the interest rate earned on fully invested securities โ RECEIVED Function โ Calculate the maturity value received from discounted securities watch?v=WDwYz-oGcV4?si=7sO1r1A0F9y05Rz469Views2likes0CommentsStop Documenting Power BI Manually: 5 Claude AI Hacks
Claude AI + Power BI (via MCP) Claude AI can now: Read your Power BI semantic model Audit your DAX Create new measures Query your data live โก In this video: the 5 highestโvalue things to do right after connecting Claude to Power BI, demonstrated on a real, messy, productionโstyle model. Youโll see Claude: Autoโdocument an entire model in ~90 seconds Catch real DAX errors (divideโbyโzero, duplicated measures) Write and insert a Sales YoY Growth % measure with proper blankโhandling Answer data questions with live DAX queriesโno visuals needed Flag relationship problems that silently produce wrong results ๐ Which one are you trying first? watch?v=V-1er3Q_lrQ278Views0likes2CommentsCreate an Income Statement or P&L report in Power BI
Download the template here: https://bit.ly/3GHZVfe Or Try the visualizations free here: https://bit.ly/41o0EeR Visualizing something like a P&L statement is still not the standard but Power BI is meant for visualization! Keep the tables in Excel and start visualizing your financial data now! watch?v=jszm5Ib9MkU?si=30GudEn02YRn9C8k4.4KViews0likes1CommentPL-300: Building Interactive Dashboards and Data Alerts in Power BI | Ilgar Zarbaliyev
In this free virtual session, you'll learn how to build interactive Power BI dashboards and set up automated data alerts to monitor your data in real time โ a must-know skill for the PL-300 exam and real-world business reporting. ๐ This session is part of the Azerbaijan Data & AI Meetup Group's 6-session PL-300 study series, hosted as part of Microsoft's Data Days 2026 global learning initiative. ๐ง What you'll learn: โ How to build interactive dashboards in Power BI โ How to use slicers, drill-throughs, and bookmarks for interactivity โ How to set up Data Alerts to monitor key metrics โ How to configure alert thresholds and notifications โ PL-300 exam tips for this topic watch?v=nxVFcqaJvBs215Views0likes0Comments