User Profile
MaxBronder
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Re: Implementing row level security for groups in a lakehouse
Hi Anonymous it´s an answer but definitely not a solution. Basically you´re saying that currently there is no way to implement row level security for AD groups, correct? It´s very disapointing, I can hardly imagine any use case where usernames would make any sense. Can you at least tell if it is on the roadmap to add ad group support? thx and KR2.2KViews1like2CommentsRe: Notebook execution failed at Notebook service with http status code - '200'
Hi Nikhilan, I´m facing the same issue while trying to execute a fabric notebook with the visual studio code extension. Regarding your suggestions, how can I check the MWC configuration for my notebook and change it to the correct settings? Thanks and KR Max2.4KViews0likes0CommentsImplementing row level security for groups in a lakehouse
Hi everyone, I'm currently looking for a solution to implement row level security based on group membership for lakehouse tables. From what Microsoft describes in the documentation only the USER_NAME(), SUSER_NAME() and SUSER_SNAME() are currently supported, which I dont find helpfull. Is there any workaround, I havent found yet? Thx and KR2.3KViews2likes8CommentsRe: DataFlow Gen2 104100 Couldn't refresh the entity because of an internal error
Hi we're facing similar issues, but what is bizzar is, that the data is actually loaded into the staging lakehouse. So somehow, the gateway can reach it, but as the data flow tries, to write from staging to destination lake house it doesnt work. And the error messages are not helpfull at all... KR5.7KViews0likes0CommentsBest practice to substitute udf scalar value functions
In our current onprem data warehouse we have many scalar value functions with complex physics calculations. Because scalar value functions are not supported I'm wondering what is the best practice now to substitute them. Converting them to a multi statement tvf could be a solution, but they are also not supported. Is this limitation only for preview or will there still be no support for Scalar and Mulit tvfs by the date of GA? And if so, what would you recommend on how the replicate this functionality? KRSolved2.6KViews0likes3CommentsRe: Can not insert null value error for nulllable column
Hi Anonymous Thanks for your answer, unfortunately the column was neither primary key, foreign key or use in calculations. Nethertheless I found a solution, or more like a workaround. The columns in the Insert statement have been in a different order than the columns were ordered in the create table. So indeed, there were NULL values for a not null column, but it was not the one displayed in the error message, but the one that would have been in the same position in the table. So for me that sounds like a bug. Thx and KR Max5.9KViews0likes5CommentsCan not insert null value error for nulllable column
During an INSERT statement I´m always receiving this error The column here is defined as nulllable and I even recreated the table multiple times to assure that. The error also appears if I´m using ISNULL(column, 0) or if I just put a "0". I also tried to comment this column out but then the error just came for the next column, and the next column and so on...Solved6KViews0likes8Comments
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.