Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Converting import mode tables into data lake in tabular editor 3 (trial)

Hello Guys,

I am using link from here:
https://docs.tabulareditor.com/common/CSharpScripts/Advanced/script-convert-import-to-dlol.html 

in order to move my report semantic model (import mode) into model in lakehouse.
But i am getting error:

 


Anyone tested it? 
How to rebind my semantic model into one lake semantic model easily? 

Best,
Jacek

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jaryszek,

    Thanks for reaching out to the Microsoft fabric community forum. The error is clear, your dataset/semantic model is on compatibility level 1601, but the script is creating a DirectLake partition, which requires compatibility level 1604. That’s why it fails at C# script line 83 on table Fct_EA_AmortisedCosts (“New Entity Partition”). You can open the model in Tabular Editor and select the Model object and change CompatibilityLevel from 1601 to 1604 (Power BI mode), now save the change and run the same script again.

    After the model is at 1604, the DirectLake partition step should go through and you can proceed with rebinding to the Lakehouse.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jaryszek,

    Thanks for reaching out to the Microsoft fabric community forum. The error is clear, your dataset/semantic model is on compatibility level 1601, but the script is creating a DirectLake partition, which requires compatibility level 1604. That’s why it fails at C# script line 83 on table Fct_EA_AmortisedCosts (“New Entity Partition”). You can open the model in Tabular Editor and select the Model object and change CompatibilityLevel from 1601 to 1604 (Power BI mode), now save the change and run the same script again.

    After the model is at 1604, the DirectLake partition step should go through and you can proceed with rebinding to the Lakehouse.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.