When adding or removing a column from a Lakehouse table, the table stops working in the SQL endpoint and Power BI semantic model. I hope this can be fixed, so that adding or removing columns f...
fbcideas_migusr
2 years agoNew Member
Thank you!
It seems to me that adding colum is now working. That is very useful for working with Lakehouse together with Direct Lake Semantic Model :-)
I am able to use the following syntax in notebook cell to add columns to Lakehouse table "%%sql ALTER TABLE tableName ADD COLUMN columnName columnType;" and the table keeps working in the SQL endpoint and semantic model.
Could you please confirm that this is supported, as this seems to be working now but didn't work earlier?
Remove column doesn't seem to work yet. I think that will also be a useful feature for working with Lakehouse in conjunction with Direct Lake Semantic Model.
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael5 hours agoHelper INew3Views0likes0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor6 hours agoSuper UserNew2Views0likes0CommentsNative Page-Level Security (PLS) or Dynamic Page Visibility based on RLS Roles
Description: Currently, Power BI provides robust Row-Level Security (RLS) to restrict data rows, but it lacks a native mechanism to restrict or hide entire report pages based on user roles or USERPRI...Erick1817 hours agoNew MemberNew5Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx19 hours agoNew MemberNew5Views0likes0CommentsPower BI Subscriptions: Suppress OOO Replies and Improve Sender & Management Options
With the recent changes to Power BI subscription email delivery, Out of Office and other automatic replies can be returned to the individual subscription owner. For automated subscriptions sent to l...svcrowell19 hours agoNew MemberNew18Views2likes0Comments