change Dataset(import) to directlake mode

[jwryu]

Hello, 

I am using Azure Synapse and there are several reports in power bi service that uploaded before MS Fabric came out. 

Is there ways to change those reports(datasets) from Import mode to DirectLake mode?

Thanks

[Anonymous · Accepted solution]

Hi @jwryu ,

You can follow the instructions provided in the link I sent. Measures etc. are migrated to the new Direct Lake model. Calculated columns are not as they are not supported in Direct Lake mode.

With the help of Dataflows Gen2 you will create delta tables in your Fabric lakehouse. These tables can then be used for your Direct Lake model. Non-supported objects are not transferred (i.e. calculated columns, calculated tables, relationships using columns with unsupported data types etc.).

Docs to refer -
GitHub - m-kovalsky/Fabric: Direct-lake-migration

Hope this is helpful. Please let me know incase of further queries.

[Anonymous]

Hi @jwryu ,

Thanks for using Fabric Community.
You can refer this doc for better help in your case - GitHub - m-kovalsky/Fabric: Direct-lake-migration

Hope this is helpful. Please let me know incase of further queries.

[jwryu]

Thanks for the reply. it helps a lot!

i just need one more question.

as i understand, when i get those directlake mode semantic models, calculated columns and measures are gone. then, is there any other suggestion to keep those?

e.g. how to load those tables in semantic models? should I load them in Lakehouse or Warehouse, then add columns there and use it to rebuild the report? 😂

[Anonymous · Accepted solution]

Hi @jwryu ,

You can follow the instructions provided in the link I sent. Measures etc. are migrated to the new Direct Lake model. Calculated columns are not as they are not supported in Direct Lake mode.

With the help of Dataflows Gen2 you will create delta tables in your Fabric lakehouse. These tables can then be used for your Direct Lake model. Non-supported objects are not transferred (i.e. calculated columns, calculated tables, relationships using columns with unsupported data types etc.).

Docs to refer -
GitHub - m-kovalsky/Fabric: Direct-lake-migration

Hope this is helpful. Please let me know incase of further queries.

[jwryu]

It's perfect!

Thank you

[Anonymous]

Glad to know your query got resolved. Please continue using Fabric Community for your further queries.

[jwryu]

umm,, can i get little more help here?

I've succeeded loading the tables to lakehouse via Dataflow Gen2

i am failing below job,, new semantic model is created but being empty

[Anonymous · Accepted solution]

Hi @jwryu ,

Can you please install the latest .whl file and give a try?

%pip install --upgrade "https://github.com/m-kovalsky/Fabric/blob/main/Direct%20Lake%20Migration/fabric_cat_tools-0.1.5-py3-none-any.whl"

In case if you have any further issues, I suggest you to check here - Issues · m-kovalsky/Fabric · GitHub

You can also open a new issues here, by that way team can see it and guide you. By this way everyone can be benefit as well.

Hope this is helpful and resolves your query.