User Profile
WaelGouader
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Sort column in table by another column when table is from Lakehouse
Hi Alaahady, You’re right that sorting a column by another column in Lakehouse-sourced semantic models is currently limited in the Service compared to Desktop. At the moment: The “Sort by Column” option is not exposed in the Service UI for Lakehouse tables or direct Lakehouse semantic models. You need to set the sort relationship before publishing: Either in Power BI Desktop while building your semantic model, Or by using a Date table with a sort column already aligned in your Lakehouse table. If you need to sort “Week of Year” correctly: ✅ In your Lakehouse, add a column like WeekSort (e.g., Year * 100 + WeekOfYear) that ensures correct chronological sort order. ✅ When creating your semantic model (or if using Desktop to build it before publishing), use “Sort by Column” there before publishing to the Service. Unfortunately, there is no toggle in the Fabric Service alone to set “Sort by Column” after the model is published from Lakehouse, and yes, this is a known gap many are waiting to be improved. Thank You1.8KViews0likes0CommentsRe: Send Images in Teams Notifications from Fabric Notebooks
What I’ve found works well is using Power Automate: After PySpark validations run in Fabric, I upload the plot image to Blob Storage. Then I trigger a Power Automate HTTP flow by sending a simple POST with metadata and the blob URL. Power Automate sends a message to the Teams channel with an adaptive card that includes the image. Thank you1.6KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.