Tag Archives: Power BI

dailybitalks.com Microsoft Fabric

Understanding the Difference Between Warehouse and Lakehouse in Microsoft Fabric

Leave a reply

In today’s data-driven world, organizations are increasingly relying on robust data infrastructure to manage and analyze vast amounts of information. Microsoft Fabric provides comprehensive solutions to address these needs, including data warehouses and data lakehouses. Understanding the differences between these two approaches is crucial for leveraging their capabilities effectively. In this blog, we’ll dive into the distinctions between data warehouses and data lakehouses within the Microsoft Fabric ecosystem.

Continue reading →
dailybitalks.com Fabric

Power BI Tips: What is Certified or Promoted Semantic Model(Dataset)


Power BI is consistently expanding its footprint in the enterprise environment. One lesser-known but highly valuable feature is the capacity to certify datasets, which enables organizations to signal to end users that certain datasets are more reliable. We are going to explore this valuable yet often overlooked feature, and to discuss the difference of promoted and certified dataset and use cases of when to use which.

Continue reading →
DailyBITalks Tableau Fixed LOD

Tableau to Power BI : How to Use Tableau Fixed LOD in Power BI

Leave a reply

If you’ve navigated Tableau’s powerful Level of Detail (LOD) function, you know its complexity and potential for creating impactful visualizations. Now, whether you’re transitioning from Tableau to Power BI or need to excel in both platforms with limited Power BI skills, fear not! In this series, we’ll unravel the mysteries of applying Tableau’s three main LOD functions in Power BI.

Continue reading →
Power BI Tips: Implicit and Explicit Measure

Power BI Tips: What are Implicit and Explicit Measures?

Leave a reply


There are two types of measures in Microsoft Power BI models: implicit and explicit. Implicit measures are automatic and summarize column data in visuals.

Explicit measures, also referred to as just measures, are custom calculations you create for your model. Put simply, implicit measures are columns that can be aggregated automatically, while explicit measures are custom calculations defined using DAX, and is THE measure that we are familiar of.

Continue reading →
Tableau to Power BI --- How to Convert If/Else to Dax Switch Function

Tableau to Power BI — How to Convert If/Else to Dax Switch Function

Leave a reply

If/esleif/else is one of the the most used functions in Tableau calculation and unfortunately, it can not be applied verbatim in Power BI to achieve the same goal. The equivalent function in Power BI DAX language is the Switch() function and it works especially well on multiple scenarios, it can be used to convert either if/elseif/else statement of possibly case/when query in Tableau.

Continue reading →