Here are the slides for my Intro to Lakehouse in Microsoft fabric. If you are new to Microsoft Fabric, check out my post here for an intro. Introdcution-to-Lakehouse-in-Fabric-2023-09-11-Shabnam-Watson-2Download I will upload sample notebooks later today and update this post.
Category: Modeling
Incremental Refresh for Power BI datasets based on a numeric column (Year): Working with Parquet/Delta files in Azure Synapse Analytics
The most common scenario for setting up the out of the box incremental refresh in Power BI is to base it off of a datetime column; however, there are cases when you may want to set up incremental refresh based off of a column with a data type other than datetime. Examples are when you … Continue reading Incremental Refresh for Power BI datasets based on a numeric column (Year): Working with Parquet/Delta files in Azure Synapse Analytics
Hybrid Tables (In Power BI) Q&A
Are Hybrid Tables tied to a developer license type? No. Incremental Refresh and Hybrid tables are tied to workspace (dataset) type. They are set up in Power BI Desktop. A developer must have Pro or Premium Per User (PPU) license to publish the report to the service. See the next two paragraphs for workspace (dataset) … Continue reading Hybrid Tables (In Power BI) Q&A
How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?
As you may have already heard, one of the easiest ways to reduce a Power BI model (dataset) size is by splitting DateTime columns into separate Date and Time columns but the question is how much space reduction can you achieve by doing so. As I show in this blog post, the reduction can be … Continue reading How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?