Category: Lakehouse

19 Nov

SQL Database in Fabric – What, Why, and How?

by Nikola

1 Comment

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the...

13 Oct

Data Modeling Databases Lakehouse Microsoft Fabric T-SQL

How to overcome the Identity column limitation in Microsoft Fabric

by Nikola

7 Comments

Identity column feature is an excellent example of the "missing puzzle" in Microsoft Fabric. Hence, we still have to rely on some workarounds and "hacks"...

29 Sep

Data Modeling Lakehouse Learning Mastering DP-600 Microsoft Fabric

Mastering DP-600 Exam: Implementing Star Schema in Fabric Lakehouse

by Nikola

1 Comment

You've heard that Star schema IS the preferred way for modeling data in your BI solutions. But, how do you create one in the Fabric...

21 Sep

Direct Lake Lakehouse Microsoft Fabric Power BI

THE Strongest Link! 5 Reasons why Semantic Link IS the Fabric big deal

by Nikola

3 Comments

Learn how Semantic Link feature will transform the world of analytics we know today!

17 Jun

Direct Lake Lakehouse Microsoft Fabric SQL Server T-SQL

How to bring SQL Server data into Microsoft Fabric

by Nikola

4 Comments

Options, options...In this article, you'll learn what are the possibilities for bringing your on-prem SQL Server data to Microsoft Fabric

23 May

Lakehouse Microsoft Fabric Power BI Power Query

What is a Power Query Template and why it’s a big deal in the era of Fabric?

by Nikola

2 Comments

Power Query Template is one of the "hidden gems" for moving your data from existing Power BI solutions to Fabric

04 May

Data Modeling External Tools Lakehouse Learning Mastering DP-600 Microsoft Fabric Power BI

Mastering DP-600 Exam: Implement Calculation Groups

by Nikola

1 Comment

Calculation groups are one of the most powerful features in Power BI to reduce the data model complexity and measure redundancy!

06 Apr

Data Modeling Data Visualization Direct Lake Lakehouse Microsoft Fabric Power BI

Migrate Existing Power BI Semantic Models to Direct Lake – A Step-by-step Guide!

by Nikola

8 Comments

Need to migrate existing Power BI reports from Import to Direct Lake mode? Michael Kovalsky provided a straightforward solution to tackle this challenge effectively

29 Mar

Databases Lakehouse Microsoft Fabric Relational Databases SQL Server