Loading Fabric Lakehouse Tables with partitions
When loading data, it is always important to load the data with performance and scalability in mind. For lakehouse tables to return queries quickly and to scale it is essential to load your lakehouse tables with partitions. What I am going to show you in my blog post today is how to load data into a Lakehouse table where the…
Microsoft Fabric
1
SSIS – Dropping Partitions in SQL Server Analysis Services (SSAS) with XMLA and Analysis Services DDL
Below are the steps that we have integrated into SSAS using SSIS so that we can then drop our old SSAS Partitions using SSIS and XMLA. Example: · We are going to drop our oldest partition from Measure Group called Fact InternetSales 1, which is in our Adventure Works cube. · The actual Cube partition name is called: o …
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized