---
title: "Discussion on \"Power BI Direct Lake Mode : Frequently Asked Questions\" | Hashnode"
description: "Discussion on \"Power BI Direct Lake Mode : Frequently Asked Questions\". A comprehensive guide to Direct Lake datasets, one question at a time"
url: "https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Power BI Direct Lake Mode : Frequently Asked Questions](https://fabric.guru/power-bi-direct-lake-mode-frequently-asked-questions?utm_source=hashnode&utm_medium=feed)

A comprehensive guide to Direct Lake datasets, one question at a time

May 24, 2023 · 27 min read · fabric.guru  
Updated Feb 16, 2024  
Read the article

-   [#fabric](https://hashnode.com/tag/fabric)
-   [#data-analytics](https://hashnode.com/tag/data-analytics)
-   [#business-intelligence](https://hashnode.com/tag/business-intelligence)
-   [#microsoftfabric](https://hashnode.com/tag/microsoftfabric)
-   [#directlake](https://hashnode.com/tag/directlake)

## Written by

[Sandeep Pawar](https://hashnode.com/@PawarBI)

@PawarBI

  
[View profile](https://hashnode.com/@PawarBI)

Building Data Analytics and Data Science solutions using Microsoft Fabric | Principal PM, Microsoft Fabric CAT

Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.

## Responses 7

Markdown supported · ⌘↵ to post

[Gerald Baldie](https://hashnode.com/@geraldbaldie)

[Feb 24, 2024](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/65d9e36ae30e34a50377e281)

Buy High Quality Counterfeit Money/Buy cloned cards online/Buy PayPal Top-up/WhatsApp…..+49 1521 9324117/Telegram: @matrixccc [t.me/thematrixshops/https://thematrixcartel.store](https://t.me/thematrixshops/https://thematrixcartel.store/)

Fake Euro notes and Cloned credit cards available for sale. We also do PayPal transfer Topups. Tap in for more information on our services. Telegram username: @matrixccc [t.me/thematrixshops](https://t.me/thematrixshops) [thematrixcartel.store](https://thematrixcartel.store/) Whatsapp +49 1521 9324117 Ψεύτικα χαρτονομίσματα ευρώ και κλωνοποιημένες κάρτες προς πώληση Ψεύτικα χαρτονομίσματα ευρώ και κλωνοποιημένες πιστωτικές κάρτες προς πώληση. Κάνουμε επίσης PayPal μεταφορά Topups. Πατήστε για περισσότερες πληροφορίες σχετικά με τις υπηρεσίες μας. Όνομα χρήστη Telegram: @matrixccc [t.me/thematrixshops](https://t.me/thematrixshops) Κανάλι Whatsapp +49 1521 9324117

[thematrixcartel.store](https://thematrixcartel.store/)

Buy counterfeit money Grade AAA Quality Counterfeit Money For Sale Buy Greece (EUR €) The Matrix Cartel [thematrixcartel.store](https://thematrixcartel.store/)

WhatsApp…..+49 1521 9324117

[Дауд камаев](https://hashnode.com/@Tecv)

[Feb 24, 2024](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/65d9e028fe98a170d4e0fea6)

Yyhfdhkhvfh jb u h u uvbh

[Christiano Chamma](https://hashnode.com/@christianochamma)

[Feb 16, 2024](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/65cf68d4e6065ea18db39e6e)

Regarding the question "If I create a table in Datawarehouse, can it be used for Direct Lake?", do you know if this has changed? From the Microsoft Learn site "directlake-overview" it appears that Warehouses are now supported for Direct Lake. I did a test using Performance Analyzer in Power BI Desktop and it didn't show "Direct Query" for a table in a Warehouse. So can I conclude that Warehouses are now supported for Direct Lake?

[Sandeep Pawar](https://hashnode.com/@PawarBI)

[Feb 16, 2024](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/65cf68d4e6065ea18db39e6e#reply-65cf6e5fd8f1ebdba1f6e02b)

Hi Christiano, yes DWH supports direct lake. I have been behind updating this blog.

[Guillaume Berthier](https://hashnode.com/@rabbyn)

[Dec 27, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/658c0d4b9dda5632bb47592f)

Hello [Sandeep Pawar](https://hashnode.com/@PawarBI), thanks for this "reference" post, it's in my bookmarks (as well as other of your blog posts :p )

Question : About the section "If I create a table in Datawarehouse, can it be used for Direct Lake ? No. Currently, only Lakehouse can be used for Direct Lake dataset".

![image.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1703677300403/c94facee-29fe-4e31-baaf-35e6d71ae5e1.png)

\=> I think that changed since you created this post, right ? from my perspective I see that the tables I created in my Warehouse have the storage mode set to "Direct Lake" in model view.

Same for the views created in Warehouse, everything seems to be "Direct Lake" enabled everywhere. Can you confirm that understanding or is there still some exceptions ? (I didn't find much about that matter in the official Microsoft documentation). Thanks

[Rafael Sá](https://hashnode.com/@rafaelsa)

[Nov 23, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/655f9aa15df79790e2b074ce)

Hi [Sandeep Pawar](https://hashnode.com/@PawarBI)., thanks for teh very detailed article and explanations. When it comes to fabric costs, if I have a f64 license do I have a free storage quota on onelake like it was with power bi premium or with fabric storage always has a related cost ? Another doubt is, when a connect through PBI desktop to a lakehouse, does it inccur in egress costs ou it depends onthe storage model(Import,direct query/directlake)?

[Kurren Nischal](https://hashnode.com/@Kurren)

[Jul 24, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/64be492a8be04301f9cf8b79)

Where I see potential for this is a real-time dashboard using structured streaming. If you want to make a real time dashboard currently, it looks like you need to structure your schema in a different way (eg streaming datasets should only hold temporary data). Using direct lake with structured streaming seems to not have this limitation. Can you do a blog post covering this?

[Timo Riikonen](https://hashnode.com/@TimoR)

[Jun 6, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/647f2f95a9021732d365a617)

Sorry, you have answered to this already. Never mind.

[Timo Riikonen](https://hashnode.com/@TimoR)

[Jun 6, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/647f2f7ea9021732d365a60c)

Thank you Sandeep for the excellent post.

Your answer to "When and how does caching occur?" Could you explain the settings on Fabric Dataset caching, how do different settings change your answer?

[Alex Ravens](https://hashnode.com/@alex12445)

[Mar 1, 2024](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/647f2f7ea9021732d365a60c#reply-65e192e2e3a1cb078d7bbc2e)

Sushiro Menu Singapore stands out as a top-notch dining destination for sushi enthusiasts and Japanese cuisine lovers. [sushirosg.com](https://sushirosg.com/)

[Sanjay Khadilkar](https://hashnode.com/@skhadilkar)

[May 31, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/6477659c445c91ce375dac68)

Hi Sandeep, thanks for very detailed information on DIrect Lake. I understand that at the moment calculated tables, calculated columns, calculation groups etc are not supported.

However, any idea if there are plans to support them in future?

Thanks, Sanjay

[Sandeep Pawar](https://hashnode.com/@PawarBI)

[May 31, 2023](https://hashnode.com/posts/power-bi-direct-lake-mode-frequently-asked-questions/646d737aa3bf27819cb3c1c0/comment/6477659c445c91ce375dac68#reply-647787d68d2851ce07116141)

Hi Sanjay, thanks! DAX cannot be used directly in pyspark or SQL so DAX caluclated columns and tables wont be supported. You will need to use Python. Or when the sempy library becomes available, you will be able to run DAX measures in the notebooks using python which will allow you to add calculated tables/columns to the dataset. It wont be as straightforward but possible.