Capacities, Workspaces and Access Control in Microsoft Fabric

Рет қаралды 9,324

Күн бұрын

Download the Excalidraw file here: www.skool.com/microsoft-fabri...
FREE 40-minute Fabric fundamentals course: www.skool.com/microsoft-fabri...
So you want to move your analytics workloads from a Power BI-centric model to a Fabric-centric model? But how do you do that?
This video is the second in the series where walk through mistakes to avoid when setting up your Microsoft Fabric environment. I walk about setting up capacities, workspaces, workspace-level sharing, item-level sharing, cross-workspace constraints and more.
Catch up on the Power BI to Microsoft Fabric Transition Guide series here: • Power BI to Fabric Tra...
Timeline
0:00 Intro
1:26 Mistake 1
3:56 Mistake 2
7:04 Mistake 3
8:20 Mistake 4
10:42 Mistake 5
12:06 Mistake 6
13:30 Mistake 7
#powerbi #microsoftfabric #dataanalytics

Пікірлер: 30

@qayedjohar 3 ай бұрын

I have been reading through many forums and watched videos, but couldn't all required users/item level access information which this video is brought. It is crisp, to the point and clears all understanding very well. thanks for putting the effort to create this.

@LearnMicrosoftFabric 3 ай бұрын

Good to hear that it clarified some things for you! Thanks for watching!

@sergeiillarionov4057 2 ай бұрын

This level of granularity is outstanding. Thank you for the content.

@LearnMicrosoftFabric 2 ай бұрын

👍 thanks! Yes the details are important for those looking to implement this stuff in the real world!

@ljloaizap 4 ай бұрын

Your content is gold! Thank you so much for sharing these brilliant videos with the community, and please keep it up! :)

@LearnMicrosoftFabric 4 ай бұрын

Thanks for watching! Glad you're enjoying, lots more in the pipeline :)

@LearnMicrosoftFabric 4 ай бұрын

You can download the Excalidraw file used in this video here: www.skool.com/microsoft-fabric/classroom/c75b239c?md=f439db030567425a88426d7bb8742dd5 What did you think of this video? Learn something new? Let me know below 👇😃

@jampeauk 4 ай бұрын

Great channel, love your content.

@LearnMicrosoftFabric 4 ай бұрын

Cheers James, thanks for watching!!

@azobensadio260 4 ай бұрын

This is a great presentation, i appreciate a lot, thanks

@LearnMicrosoftFabric 4 ай бұрын

thanks for watching!

@GuillaumeBerthier 4 ай бұрын

Thanks Will for all the efforts you are putting on bringing valuable contents on #Fabric, they are golden and definitely the best channel on that matter from far. I never missed any of your video (thanks to the subscribe) PS : some time ago i thought you gave up since you didn't post any new content for weeks but im happy you're back on track 😉 All the best for your channel and your learning web site, ill sign up for it!

@LearnMicrosoftFabric 4 ай бұрын

Very kind of you to say Guillaume, thanks! Haha yes I did take a little break, I was working full-time and it was a very busy period in my life. But then I quit that job and now focus 100% on teaching Fabric, so there will be lots more (hopefully high-quality) videos to come. Thanks a lot for your support

@Steven-tr4rp 4 ай бұрын

Your 7th point also affects Lookup activities too. I might have a work around (possibly) - in the Source there's a field for Lakehouse. If you add the Lakehouse ID (a GUID) into the Dynamic Content section (Click OK), add the correct Workspace ID (Again a GUID) and refresh the 'Tables' section, it might show the tables in that Lakehouse. (it does for me) It's not perfect as it sometimes resets the options if you adjust the Copy Data activity, but I've successfully copied from one workspace to another from a pipeline in a third workspace. Haven't tried it with Stored Procs yet.

@LearnMicrosoftFabric 4 ай бұрын

Ah nice, thanks for that Steven!

@oskarlindberg4869 4 ай бұрын

Golden! Such a great channel:-)

@LearnMicrosoftFabric 4 ай бұрын

Hey Oskar, really appreciate that man - thanks for commenting! Just getting started!! 😊

@jaggyjut 3 ай бұрын

One of the best channels on data analytics. Is there a video on fabric license costs pls

@LearnMicrosoftFabric 3 ай бұрын

Thanks for your kind words! I did a video on licensing and costs when Fabric was first released, a few minor details have changed since then so I will probably record an update video soon :) here it is: kzfaq.info/get/bejne/rZpoZKWEvdGUcqs.html

@joseangelmartinez308 2 ай бұрын

Thanks Will for all your effort on this kind of videos! New sub here :) Keep going!

@LearnMicrosoftFabric 2 ай бұрын

Welcome to the channel, thanks for joining us! I'm glad are enjoying!

@hentone 3 ай бұрын

Great video thank you :)

@LearnMicrosoftFabric 3 ай бұрын

Thanks to you for watching!

@GuillaumeBerthier 4 ай бұрын

... By the way, taking about cross workspace limitations i found a "nice" one recently... step_1 Create a lakehouse L1-EMEA in a Workspace EMEA (Hosted on any EMEA Fabric capacity) then an other Lakehouse L2-APAC from a Workpace APAC (hosted on any APAC Fabric capacity). Step_2 create a Table shortcut from L2-APAC pointing to any tables of L1-EMEA . Step_3 open the L2-APAC and read the shortcuted table with a notebook = all good.....Now open L2-APAC SQL Analytics endpoints or the Default L2 semantic model and you'll see they will be empty 😮..... It's a "cross-workspace/region" scenario limitation that Microsoft is now aware and hopefully will find a solution soon (since this architecture scenario will be rather common for Global companies)

@LearnMicrosoftFabric 4 ай бұрын

Oooh that is very useful to know, thanks for highlighting that!

@alexmcqueen5563 2 ай бұрын

Would be good to call a stored procedure for a data warehouse in another workspace. Could have a central warehouse for auditing, meta data etc which all pipelines used regardless of workspace.

@LearnMicrosoftFabric 2 ай бұрын

I added an Idea for that, and it is apparently ‘Planned’. You can vote here to give it more urgency ☺️: ideas.fabric.microsoft.com/ideas/idea/?ideaid=b8afba33-2dcf-ee11-92bd-6045bdb0416e

@alexmcqueen5563 2 ай бұрын

@@LearnMicrosoftFabric will do :)