Fabric Sessions: Fabric Capacity On Demand & Overview of Semantic Link
We are excited to invite you to our upcoming community event featuring two insightful sessions: Session 1: Title: Fabric Capacity on Demand: Pause and Resume Your Microsoft Fabric Capacity from Power BI Date: February 13th, 2024 Time: 18:00 - 18:30 CET Speaker: Ioana Bouariu Session Description: Struggling with fluctuating data demands in your Microsoft Fabric environment? Learn how to build a solution that allows you to control your Fabric capacity on demand directly from Power BI with the push of a button. Questions If any , Then Break Session 2: Title: Introduction to Semantic Link in Microsoft Fabric Date: February 13th, 2024 Time: 19:00 CET Speaker: Sandeep Pawar Session Description: Semantic Link in Microsoft Fabric offers an innovative way to access data and semantic information contained in a semantic model. In this session, Sandeep will provide an overview of Semantic Link and outline practical use cases to help you get the most out of Fabric. To attend, mark yourself as "Going" on the event page and add to your calendar. The join link will be shared closer to the session date. Check back on the event page at session time for the link. Looking forward to insightful discussions!Data Saturdays Madrid
Uno de los eventos más importantes de España en el ámbito de los datos, la inteligencia artificial, la analítica y las plataformas de datos de Microsoft llega el 29 de Noviembre a Madrid: Data Saturday Madrid. 6 tracks, 42 sesiones, ponentes muy top y MVPs nacionales en Datos, SQL, AI, Power BI y Fabric. Además, habrán sesiones de Microsoft Fabric CAT, Microsoft Azure SQL Product Group y Databricks PMs . Nuestros Co-líderes de Cloud&Data Valencia impartirán sesiones: Con Delia Sanchis descubriremos cómo la Inteligencia Artificial (IA) y el Machine Learning (ML) pueden ser aliados poderosos para predecir y prevenir incendios forestales. Analizaremos factores críticos y realizaremos una demostración práctica con Microsoft Fabric! Fran Lens mostrará una de las novedades más potentes de SQL Server 2025: Change Event Streaming, una funcionalidad que permite emitir cambios en las tablas en tiempo real, sin necesidad de procesos batch ni lecturas periódicas. Prepárate para un día repleto de conocimiento de altísimo nivel! ¿De verdad te lo vas a perder?
Running total on a large scale dataset
Hi all, I'm having a 80 million record dataset. When I was doing the POC report that has only account number, I used the following fomular to generate my balance: Balance = [Opening balance] + CALCULATE( SUM(transaction[Amount]), FILTER( ALLSELECTED(transaction), [Index] <= MAX(transaction[Index]) ) ) The above fomular works exactly as what I want. However, when I load not all my data, but just over 10 million data, this fomular gives me an error message saying that it's running out resources. Then I thought about dividing my original transaction table into pieces first as for my report, anyway, one account number and only one account number must have been selected. I used the following fomular to divide my table: FilteredTable = CALCULATETABLE( 'transaction', FILTER ( 'transaction', 'transaction'[Account_number] = SELECTEDVALUE('transaction'[Account_number]) ) ) It gives me an empty table, if I replaced "SELECTEDVALUE('transaction'[Account_number])" by a fixed text string, new table will be created with data. Anybody can help me on this issue? Thanks in advance.
The most efficient way to perform lookup in table
Hello guys, how are you? I'm having a very specific issue, and even knowing how to solve that in theory, I'm having serious performance problems, due to the obligatory use from a very heavy database - an azure cube developed by my company that provides data worldwide. I've come with an example in a fact table, where I have trips from loading vehicles with an initial weight in the beggining of the trip. I need to create a measurement (can't make new columns in the direct query) that calculates the initial weight for the next trip from this same vehicle. It's a very simple task with ALL filters and on, however the real table is not retrieving the data due to the mentioned size of the datamodel. I've been trying using the OFFSET funcion, but I'm not being able to make the logic work to my problem. Any suggestions? Below, the latest try I've made: Next trip weight = VAR vFrota = MAX('Shifts and Events'[VehicleUsedId]) VAR vData = MAX('Shifts and Events'[EventStartDateTime]) VAR vTab = FILTER( ALL('Shifts and Events'), 'Shifts and Events'[EventStartDateTime] > vData && 'Shifts and Events'[VehicleUsedId] = vFrota ) VAR vMenorData = CALCULATE( MIN('Shifts and Events'[EventStartDateTime]), vTab ) RETURN CALCULATE( MAX('Shifts and Events'[MeasureBeforeLoading(kg)]), FILTER( vTab, [EventStartDateTime] = vMenorData && [VehicleUsedId] = vFrota ) ) Below an example of how I'm trying to make the information appear: Thanks!
