Activity
Mon
Wed
Fri
Sun
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
What is this?
Less
More
Memberships
Learn Microsoft Fabric
Public • 4.2k • Free
4 contributions to Learn Microsoft Fabric
15d ago
in
RLS and OLS Recommendations
Have a questions regarding some of the row level security and object level security through out end to end analytics. For bronze and silver tier this will be higher level using workspaces (plan for now) but end users would like access to both Power BI reports as well as querying data from gold tier (most likely a data warehouse) and we would like to use Entra Id and setup one place for end users access. So if user A can only access Table 1 and columns X and Z, we would like to be able to restrict that access in the reports as well as DW from one place.
2
7
New comment 1d ago
0 likes • 15d
Great insights @Lukasz Obst! From what I was reading, if we try and setup on the DW or Endpoints then PowerBI will fallback to direct query which I agree, we don't want to use, was really looking at Direct Lake. Previous experience we use Analysis Services which was pretty amazing performance wise so hoping Direct Lake performance is awesome. One thing I was thinking as well is we are using Power BI as part of our implementation but why I really liked the idea of centralized RLS/OLS is a larger company and I know they have some Qlik users and stood up a few instances so if they hook into our data warehouse and expect RLS/OLS to work, even thought outside our implementation is a concern that I would want to raise to them.
0 likes • 1d
@Pallavi Routaray Just curious what your fix was? I was also not following 100% on the gateway connection (which I thought was connecting from cloud to on-prem systems) but didn't really have anything to do with RLS?
8d ago
in
End users (Non-Tech) ability to update variable data for validatations
Hopefully this makes sense but we may have a scenario where in our pipeline for moving data from say bronze to silver and doing validation checks we will have a threshold variable that maybe changed by a end users, this picture would be making it going from say 1,000 dollar sale to 1,500 and could see this being a default and override depending on the day (say week before Christmas this number needs to go up even more). In old world of SQL and c# building days we would have a portal and user updating a table, in fabric world with notebooks, what maybe some best practices for non-tech end users to be able to configure this and can we pull this variable I guess from just another table in the warehouse/lakehouse maybe?
1
1
New comment 8d ago
13d ago
in
Workspace Structure Thoughts?
Hi Everybody... We are going to be setting up our workspaces hopefully next week and was curious if anyone has lessons learned for creating workspaces. Initially was thinking workspace for the Bronze tier, one for silver and one for gold then different ones for semantic model by subject area (Operations, Marketing, HR, etc.) Then was thinking of combining the workspaces for bronze and silver and potentially gold as well into one so we wouldn't have any potential limitations of tools. Any feedback anyone has is greatly appreciated, I also don't mind fumbling through as well as best way to learn sometimes. 😃
2
3
New comment 11d ago
1 like • 11d
Thank you for the links, yeah I have watched the Power BI to Fabric, will go back and rewatch, I think there are many options so really just trying to narrow down the best option at the moment
May 16
in
👋 New joiner? WELCOME! Two things for your first day...
1. 📖 GET UP TO SPEED: Read everything in here: #Welcome to the community! - it's a short course to help you understand the community, why it exists, what you can do here, and the community guidelines. 2. 🤝 INTRODUCE YOURSELF in this thread below! We're a friendly bunch, all with the goal of learning Fabric. Not sure what to say? You can use the template below: Hi, I'm ___, I'm from ___, I work in/ as a ___ I'm really interested in learning more about _______ ? Thank you for engaging and joining us on this exciting learning journey! 🙏 Will
Complete action
163
810
New comment 7h ago
2 likes • 15d
Hey to everyone. I am Justin, I work in the US as a consultant. New project I am starting on is building end to end analytics solution using Fabric so excited to make the move into this new world and all it has to offer! Went through the 3 1/2 hr video put together by Will and one of the best I have seen! Am curious on a few things so hopefully can help me with a few different perspectives as I go down this road!
1-4 of 4
@justin-sweet-4814
Consultant doing a little bit of everything. Love architecture, designing, implementing and mostly working with others to build cool stuff!
Active 1d ago
Joined Sep 4, 2024
powered by