Hybrid 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.
Issue Direct Query with Report
Hello Everybody, We have a PBIRS 2025-01 (Version1.22.9153.7886). I create a report with a Direct Query connection to a SQL Server 2022. There is only 3 tables without relationship All works well in Power BI Desktop for Report Server (query retrieve data and visuals works well). I deployed report on server. When I try to open the report on the Server, there is the error message : When I go to Data Source all works well : We already add a enviornment variable PBI_SQL_TRUSTED_SERVERS on PBIRS with the SQL Server Source but nothing change. Logs on PBIRS shows a szucessful connection (code 200) without any error. Somebody can help me or have an idea to investigate ? Kind Regards, Thomas
Distinct count total is correct, but the columns are not
Hi, I am new to power BI and need some help. I have a list of patient IDs and I want to get the total distinct patients per fiscal year broken down by fiscal period, but when I put it in a table with columns representing the periods, it gives me the distinct total per period not per year, which is not what I want. Only the grand total in the table is correct. e.g. Here is what I'm getting for 2023 (using a slicer): Here's what I want: Again, to clarify, each patient should only be counted once per year, and should only be counted in the first period they appear. In my dates table, I have per row every date from 2022-2025 (Jour"), and the corresponding fiscal period (P#) and fiscal year (Annee 2). In my patient data table, the relevent columns would be the patient ID and appointment date (startdatetime). I have done a lot of research and none of what I've read is giving me the correct results. I can acheive the results when working with imported data, but I need to keep it as direct query so my options are more limited. I would appreciate any help you can give!
