Version control (Git) & Deployment Pipelines in Microsoft Fabric | DP-600 EXAM PREP (4 of 12)

Free DP-600 study notes inside community: www.skool.com/microsoft-fabri...
In this video (4 of 12 in the series), we explore the next part of the DP-600 Study Guide: Managing the Analytics Development Lifecycle.This includes the following:
- Implement version control for a workspace
- Create and manage a Power BI Desktop project (.pbip)
- Plan and implement deployment solutions
- Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models
- Deploy and manage semantic models by using the XMLA endpoint
- Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models
This video is part of the DP-600 Exam Preparation series: • DP-600 Exam Preparation
Note: this video is meant to serve as a light covering of the topics assessed as part of the exam. There is a mountain of possibilities and strategies when it comes to version control and deployment - I hope to cover more of this in the future on the channel!
Timeline
0:00 Intro
1:05 Scenario starts here - Git and version control
2:18 Git and version control primer - Part 1 - Git basics
11:10 Git and version control primer - Part 2 - Branching and pull requests
17:00 Version control for Power BI projects (.pbip)
21:12 Git source control in a Fabric Workspace
26:07 Summary of version control in Fabric
28:18 Deployment solutions intro
29:35 Deployment pipelines in Fabric
34:54 Summary of deployment pipelines
36:28 Other options for deployment
37:01 Deploying semantic models using XMLA endpoint
37:56 .pbit and .pbids files
40:05 Data lineage and impact analysis
42:18 Practice Question 1
43:44 Practice Question 2
45:00 Practice Question 3
46:22 Practice Question 4
47:22 Summary and next steps
#microsoftfabric #dp600 #powerbi

Пікірлер: 68

  • @LearnMicrosoftFabric
    @LearnMicrosoftFabricАй бұрын

    Did you receive free DP-600 exam voucher today? To celebrate, let's go through version control and deployment in Fabric 😊 I'd be GRATEFUL if you dropped a LIKE, or a COMMENT - let me know what you think of the series so far! Have a great weekend everyone. Hopefully two more DP-600 videos next week 🙌

  • @chealey1877

    @chealey1877

    Ай бұрын

    Arrived in my inbox today so looking to get it scheduled asap. Liking the series and the timing is perfect!

  • @Mohit-zj8ln

    @Mohit-zj8ln

    Ай бұрын

    Microsoft fabric going to be a game changing tech and this series helping me alot

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    @@chealey1877 Awesome - great work!! 8 more videos in this series, and I plan on releasing two a week, just FYI. Should give the voucher people 3/4 weeks after the series to book their tests!

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    @@Mohit-zj8ln Yeh Fabric is pretty cool. I'm glad the videos are helping 👍

  • @chealey1877

    @chealey1877

    Ай бұрын

    @@LearnMicrosoftFabric I've done plenty of exams in the past so hoping my Power BI certification will help at least.

  • @amira_369
    @amira_369Ай бұрын

    At first I thought you’re a Microsoft technical trainer and you’re helping people to use Fabric but I was really surprised that you’re this good and you’re not working with Microsoft! AMAZING CONTENT

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    😂 thanks 🙏 hahaha no, I’m just a normal guy, but if anyone in Microsoft is watching and wants to sponsor the channel, reach out 🤣

  • @happyheart9431
    @happyheart943125 күн бұрын

    Million Thanks. God Bless you Will. You are sharing such a valuable content free. All your videos shows how much hard work you put .

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    22 күн бұрын

    no problem, thanks for watching! ☺️

  • @HimanshuRana-fv7om
    @HimanshuRana-fv7omАй бұрын

    The subscribers of the channel are not justifying the content... Great work Will👍

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Haha in a good way or a bad way? 🤔😂 thanks for watching! 🙌

  • @kevindoherty8788
    @kevindoherty8788Ай бұрын

    This content is so good, I feel guilty watching it for free. Thank you so much.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Haha thanks for watching! I’m glad you are finding it useful ☺️

  • @Jujubeterraba

    @Jujubeterraba

    18 күн бұрын

    I was thinking the same...

  • @Nalaka-Wanniarachchi
    @Nalaka-WanniarachchiАй бұрын

    Nice stuff.What is very cool is showing how it is connecting the pieces.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Yes, all these things are closely connected. Version control is the glue that binds everything together. Thanks for watching!

  • @kejmil1992
    @kejmil199219 күн бұрын

    I am mostly Power BI Developer and Admin Tenant and I am feeling overwhelmed because of the material to learn to pass DP-600. Thanks to Will I have hope I will pass it, thanks a lot with this course and a lot of work you dedicated to prepare it!

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    18 күн бұрын

    Ah sorry to the hear that :/ yeh DP-600 is a tough exam which covers a lot of different areas. I think it's normal to feel a little overwhelmed - I don't think anyone is an expert in all the areas covered. It's more of a generalist exam, which requires awareness about lots of topics, but I don't think it requires deep knowledge really about any of the topics. Feel free to join our community where there is lots of people in a similar boat going through the process: skool.com/microsoft-fabric

  • @terryliu3635
    @terryliu363514 күн бұрын

    Great video! Thank you!

  • @SteffiRs
    @SteffiRsАй бұрын

    I absolutely love your videos! Your explanations go beyond just the technical concepts and you make them very easy to understand. I even prefer your content to the Microsoft provided content. I can't wait for your upcoming videos to learn more so that I can use that exam voucher with confidence 💪

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    You got the voucher? That's awesome. I'm glad you're finding the videos useful!

  • @mattroberts9665
    @mattroberts9665Ай бұрын

    Another great video Will. Thank you I know exactly why you chose Power BI Reports in your Deployment Pipelines 😉. They're probably the most mature. I know we've discussed this issue on SKOOL, and still feel the same at the moment. Deployment through environments (whether using Deployment Pipelines or other methods) seems to have been poorly covered by Microsoft in their delivery of Fabric. Deployment Pipelines in particular has a long way to go before we can say it's Production ready, especially for Warehouses and parts of the data pipelines. Fabric is such an amazing platform, and i'm sure it will only improve over the coming months, but the deployment of Fabric Items is a big miss by the product team.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thanks Matt! Yes I think it's early days in the Git/Deployment Pipelines journey for Fabric - hopefully the functionality gets improved quickly!

  • @owennowakowski7558
    @owennowakowski755810 күн бұрын

    Super helpful videos! Keep up the great work!

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    9 күн бұрын

    Glad you're finding them helpful! Thanks for watching 🙌

  • @tecnocriollo
    @tecnocriollo8 күн бұрын

    With the workspace explanation I understood why the branch is blocked at workspace level. Because you have to set a different branch for every workspace.

  • @Karenshow
    @KarenshowАй бұрын

    I absolutely love this, thanks for sharing.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Really glad you liked it, thanks for watching!!

  • @roxanac9383
    @roxanac938323 күн бұрын

    This is golden, thanks! Can't way to finally implement version control on my Power BI projects. I also got the free DP-600 exam voucher and I'm currently preparing so I can have it scheduled in time and hopefully pass 🤞🏻

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    22 күн бұрын

    Nice work, good luck for the exam!

  • @pallaviroutaray5754
    @pallaviroutaray5754Ай бұрын

    Awesome content. very very informative Will

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thank you! Glad you enjoyed 😊

  • @jafarhussain4665
    @jafarhussain466523 күн бұрын

    Hi, Thank you for the wonderful video and Topic. A small doubt. Rather than using .pbit File, why can't we use same .pbix file as a template to reuse our report, like creating multiple copies of template in .pibx format and reuse it ? Thank you

  • @TheRamiroB
    @TheRamiroBАй бұрын

    god job!! congrats

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thanks for watching!

  • @amrosaad9730
    @amrosaad9730Ай бұрын

    Thank you.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    No problem, hope you found it useful 👍

  • @ArnoWakfer
    @ArnoWakfer10 күн бұрын

    Love your videos Will - just a suggestion. In some slides we can't see all the text as your webcam image appears over it.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    9 күн бұрын

    Thanks Arno, I will bear that in mind going forward 🙌

  • @rajbabs9846
    @rajbabs98469 күн бұрын

    15:55: Looks like you didn't address why we don't want to delete the branch "in Fabric". Can you tell why?

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    9 күн бұрын

    Ah yes, it's because if you delete the branch you can't switch back to the main branch, and eveything breaks.

  • @user-bg4wu1gs6i
    @user-bg4wu1gs6iАй бұрын

    Hi since we add a reviewer earlier when making changes in policy why we do need to again it after creating pull request

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    When setting up the policy, I was specifying who has the ability to perform a review (this might be several people in reality). When creating the pull request, I specify a particular person who I want to review it (from the list of approved reviewers. Hope that makes sense 👍

  • @chat-jpt
    @chat-jptАй бұрын

    When you are dealing with semantic model pipelines, how would you explain the difference between this and the medallion architecture? I get the latter is due to data quality/transformation. Folks tend to have a panic reaction about overhead and technical debt when hearing they need 3 layers x 3 deployment stages

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thanks for the great question! In my view, deployment stages and medallion architecture have different core goals. In medallion, we are looking to progressively improve the quality and usefulness of our datasets. Deployment pipelines are mainly used to ensure any new things you develop don't break any of the existing things you have in production. Which combination you need depends of your requirements in your org. Some will see more value in one over the other. Some will need both. Hope that helps?

  • @skalsolutions
    @skalsolutionsАй бұрын

    Great video Will! I have a question regarding the integration of Git and Deployment Pipelines. How would we effectively combine both features when managing three workspaces: dev, qa, and prod? Would it be appropriate to use one branch for each workspace in Git? Additionally, after deploying the report from dev to qa and prod using deployment pipelines, how would we utilize Git in QA and PROD environments? I understand that GuyInACube has already created a video demonstrating the use of Git for two workspaces, but I am uncertain about its integration with deployment pipelines.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thanks for watching. Yes, I put a slight caveat in the description, that this just covers the basic implementation of Git and Deployment Pipelines (enough for the DP-600). In reality there are lots of different strategies for version control and deployment, some of which I'll explore in more detail on the channel in the future definitely. Be careful if you combine both approaches. In general, I would say you only want ONE method of moving an item from Dev to Test. This can be achieved either through git branching or through the manual deployment pipeline in Fabric. If you do both at the same time, you run the risk of things getting out of sync. I personally prefer the first option, because it can be somewhat automated. Hope that makes sense?

  • @skalsolutions

    @skalsolutions

    Ай бұрын

    @@LearnMicrosoftFabric thanks a lot for your answer! Yes, make sense!

  • @bijalpatel5164
    @bijalpatel5164Ай бұрын

    Amazing Video!! I have one question: What is the correct order to work on Fabric?

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Thanks! I'm not sure I understand your question... can you explain a bit more? 😊

  • @azwarmzafar
    @azwarmzafar17 күн бұрын

    Thank you great content as usual, a question how to get the free voucher for the exam as it’s being discussed in the chat please?

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    16 күн бұрын

    I think the free voucher deal has expired, but I think you can still get 50% off in some places - take a look at the Learn Together series of videos Microsoft produced - you should find a link in those videos 👍

  • @user-md6wn1wv9i
    @user-md6wn1wv9iАй бұрын

    i have trouble in skool community after login, i got a window like update profile, after filling it there is no update or cancel button, i cant even go back to home page

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    Hi, I think I might've heard of something similar before. Be careful the file type of the image you are using in your profile. Retry and make sure you are using a PNG or JPG (and if one of those doesn't work, try the other one)

  • @osmanbaba1485
    @osmanbaba1485Ай бұрын

    Will, you smart

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    Ай бұрын

    I'm not sure about that, but thanks 😂

  • @souvanikchaudhury8890
    @souvanikchaudhury889024 күн бұрын

    HI Will, I didn't able to access the note from the link. it is blocked.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    24 күн бұрын

    I see you have now found the entrance, welcome!

  • @souvanikchaudhury8890

    @souvanikchaudhury8890

    24 күн бұрын

    @@LearnMicrosoftFabric Thanks! Will how you create a fabric workspace(Synapse Data Engineering) and link it with Azuredevops? That part is not clear.

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    24 күн бұрын

    @@souvanikchaudhury8890 You create the workspace, then go to Workspace Settings > Git integration

  • @souvanikchaudhury8890

    @souvanikchaudhury8890

    23 күн бұрын

    @@LearnMicrosoftFabric Got it! Thanks

  • @carlosnavia1361
    @carlosnavia136116 күн бұрын

  • @LearnMicrosoftFabric

    @LearnMicrosoftFabric

    16 күн бұрын

    Thanks for watching Carlos!