Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
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?
Solved! Go to Solution.
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 !!
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 !!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
80 | |
69 | |
60 |