Posts tagged #Direct Query

(Livestream Replay) Power BI Storage Modes in Microsoft Fabric - with Phil Seamark

DESCRIPTION ๐Ÿ“„

A review of semantic model storage modes available today in Microsoft Fabric. In particular, let's look at the new Direct Lake storage mode and help understand how this compares with Import and Direct Query, and when you might use each.

GUEST BIO ๐Ÿ‘ค

Phil works for Microsoft on the Fabric Customer Advisory Team (CAT) as a DAX and Data Modelling specialist.

As part of this role, he helps global enterprise customers to optimize and tune large data models to perform their best under heavy load.

Phil has over 30 years of experience in I.T. with most of that time building solutions in business intelligence and advanced analytics.

(Livestream Replay) Why OneLake is a BIG DEAL in Microsoft Fabric - with Pawel Potasinski)

DESCRIPTION ๐Ÿ“„

One of the key pillars of Microsoft Fabric is that itโ€™s lake centric and open. At the core of this pillar thereโ€™s OneLake - a single, unified storage system for all your data. In this conversation Pawel and Reid will discuss and *** demo *** the benefits of OneLake for data professionals and organizations working with Fabric.

GUEST BIO ๐Ÿ‘ค

Member of the Microsoft Fabric Customer Advisory Team (CAT), focused on community management and engagements. In his professional career Pawel has always been associated with data engineering and analytics (SQL, BI, Big Data). Founder of the Polish SQL Server Users Group (PLSSUG), today known as Data Community Poland. Regular speaker at conferences, community events and user groups. Former Microsoft Most Valuable Professional (MVP).

RELATED CONTENT ๐Ÿ”—

LinkedIn
OneLake documentation
Fabric blog
Fabric community
Fabric ideas
Fabric readiness repository

Posted on November 10, 2023 and filed under Livestreams, Fabric.

Creating a Composite Model Against a Power BI Dataset

Video by: Reid Havens

Learn how to create a composite model against a Power BI dataset, also known as (DirectQuery for Power BI datasets and Azure Analysis Services) or DQFPBIDAAS for short. ๐Ÿ˜…

Composite Models against a Power BI Dataset allows you to import tables from other data sources and combine it with your Power BI dataset.

RELATED CONTENT ๐Ÿ”—

Splitting a Report & Model
DirectQuery for Power BI datasets and Azure Analysis Services

Upgrading Import Data Models to Power BI Service Or Direct Query

Video by: Reid Havens

In this video you'll learn how to take a completed Power BI Report Model that was created using the Import method, and convert / separate the report into two distinct files for the Data Model & Report.

The biggest benefit to doing this is saving substantial time from needing to completely reproduce your report from scratch, using the Power BI Service as the data connector.