Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
cbschley
Helper III
Helper III

Difference between Light Blue & Dark Blue table header in Model View?

In one report, I have a model that contains both Import and DirectQuery tables. The DirectQuery table has a dark-blue header, which I assume is to identify DirectQuery.

cbschley_1-1712843832467.png

 

 

In another report, I have a model that is entirely coming from a semantic model. It doesn't say whether its DirectQuery or Import. All of these tables have a light-blue header. What is the difference?

cbschley_0-1712843785294.png

 

1 ACCEPTED SOLUTION
johnbasha33
Super User
Super User

@cbschley 

The difference in the colors of the table headers indicates the storage mode of the tables in your Power BI dataset.

1. **Dark Blue Header (DirectQuery)**:
Tables with a dark blue header indicate that they are using DirectQuery mode. DirectQuery mode allows Power BI to query the underlying data source directly in real-time, without importing the data into the Power BI dataset. This mode is suitable for large datasets or scenarios where you need to access real-time data.

2. **Light Blue Header (Import)**:
Tables with a light blue header indicate that they are using Import mode. Import mode means that the data has been imported into the Power BI dataset during the data loading process. Power BI stores the imported data internally, allowing for faster query performance and offline access to the data. Import mode is suitable for smaller datasets or scenarios where you want to leverage Power BI's data modeling capabilities.

In your second report where all tables have light blue headers, it suggests that all tables are imported into the Power BI dataset. If you're unsure whether a table is in DirectQuery or Import mode in this report, you can check the data source settings in the Power Query Editor or the dataset settings in Power BI Desktop to verify the storage mode of each table.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

View solution in original post

1 REPLY 1
johnbasha33
Super User
Super User

@cbschley 

The difference in the colors of the table headers indicates the storage mode of the tables in your Power BI dataset.

1. **Dark Blue Header (DirectQuery)**:
Tables with a dark blue header indicate that they are using DirectQuery mode. DirectQuery mode allows Power BI to query the underlying data source directly in real-time, without importing the data into the Power BI dataset. This mode is suitable for large datasets or scenarios where you need to access real-time data.

2. **Light Blue Header (Import)**:
Tables with a light blue header indicate that they are using Import mode. Import mode means that the data has been imported into the Power BI dataset during the data loading process. Power BI stores the imported data internally, allowing for faster query performance and offline access to the data. Import mode is suitable for smaller datasets or scenarios where you want to leverage Power BI's data modeling capabilities.

In your second report where all tables have light blue headers, it suggests that all tables are imported into the Power BI dataset. If you're unsure whether a table is in DirectQuery or Import mode in this report, you can check the data source settings in the Power Query Editor or the dataset settings in Power BI Desktop to verify the storage mode of each table.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.