Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to replicate a power bi "desktop" model in a fabric lakehouse. I have a lakehouse with all the tables loaded and I've created a semantic model. I need to create some calculated columns based on lookups to tables within the model, however, the "New Column" functionality is not available.
Am I trying to do this in the wrong place or is there something that I need to configure to allow this functionality?
Thx!
No, I don't believe you can use DAX. I was thinking how ever you created your lakehouse, like if you used Gen2 dataflows, you could replicate the logic.
This is not currently supported for semantic models derived from a lakehouse.
Please see: Learn about Direct Lake in Power BI and Microsoft Fabric - Microsoft Fabric | Microsoft Learn
As an option, you can create them in your lakehouse.
Thx. Can you use Dax in the lakehouse to do the lookups? I've not been able to figure that out.