Sign in
Log inSign up
Sandeep Pawar

15 likes

·

22.1K reads

10 comments

Sanjay Khadilkar
Sanjay Khadilkar
May 31, 2023

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

1
·
·1 reply
Sandeep Pawar
Sandeep Pawar
Author
·May 31, 2023

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.

·
Timo Riikonen
Timo Riikonen
Jun 6, 2023

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?

1
·
·1 reply
Alex Ravens
Alex Ravens
Mar 1, 2024

Sushiro Menu Singapore stands out as a top-notch dining destination for sushi enthusiasts and Japanese cuisine lovers. sushirosg.com

·
Timo Riikonen
Timo Riikonen
Jun 6, 2023

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

1
·
Kurren Nischal
Kurren Nischal
Jul 24, 2023

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?

1
·
JT
JT
Aug 29, 2023

Thank you for this amazing write up, Sandeep Pawar! So helpful.

1
·
Rafael Sá
Rafael Sá
Nov 23, 2023

Hi Sandeep Pawar., 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)?

·
Christiano Chamma
Christiano Chamma
Feb 16, 2024

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?

·
·1 reply
Sandeep Pawar
Sandeep Pawar
Author
·Feb 16, 2024

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

1
·