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
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
Ай бұрын
Arrived in my inbox today so looking to get it scheduled asap. Liking the series and the timing is perfect!
@Mohit-zj8ln
Ай бұрын
Microsoft fabric going to be a game changing tech and this series helping me alot
@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
Ай бұрын
@@Mohit-zj8ln Yeh Fabric is pretty cool. I'm glad the videos are helping 👍
@chealey1877
Ай бұрын
@@LearnMicrosoftFabric I've done plenty of exams in the past so hoping my Power BI certification will help at least.
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
Ай бұрын
😂 thanks 🙏 hahaha no, I’m just a normal guy, but if anyone in Microsoft is watching and wants to sponsor the channel, reach out 🤣
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
22 күн бұрын
no problem, thanks for watching! ☺️
The subscribers of the channel are not justifying the content... Great work Will👍
@LearnMicrosoftFabric
Ай бұрын
Haha in a good way or a bad way? 🤔😂 thanks for watching! 🙌
This content is so good, I feel guilty watching it for free. Thank you so much.
@LearnMicrosoftFabric
Ай бұрын
Haha thanks for watching! I’m glad you are finding it useful ☺️
@Jujubeterraba
18 күн бұрын
I was thinking the same...
Nice stuff.What is very cool is showing how it is connecting the pieces.
@LearnMicrosoftFabric
Ай бұрын
Yes, all these things are closely connected. Version control is the glue that binds everything together. Thanks for watching!
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
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
Great video! Thank you!
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
Ай бұрын
You got the voucher? That's awesome. I'm glad you're finding the videos useful!
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
Ай бұрын
Thanks Matt! Yes I think it's early days in the Git/Deployment Pipelines journey for Fabric - hopefully the functionality gets improved quickly!
Super helpful videos! Keep up the great work!
@LearnMicrosoftFabric
9 күн бұрын
Glad you're finding them helpful! Thanks for watching 🙌
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.
I absolutely love this, thanks for sharing.
@LearnMicrosoftFabric
Ай бұрын
Really glad you liked it, thanks for watching!!
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
22 күн бұрын
Nice work, good luck for the exam!
Awesome content. very very informative Will
@LearnMicrosoftFabric
Ай бұрын
Thank you! Glad you enjoyed 😊
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
god job!! congrats
@LearnMicrosoftFabric
Ай бұрын
Thanks for watching!
Thank you.
@LearnMicrosoftFabric
Ай бұрын
No problem, hope you found it useful 👍
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
9 күн бұрын
Thanks Arno, I will bear that in mind going forward 🙌
15:55: Looks like you didn't address why we don't want to delete the branch "in Fabric". Can you tell why?
@LearnMicrosoftFabric
9 күн бұрын
Ah yes, it's because if you delete the branch you can't switch back to the main branch, and eveything breaks.
Hi since we add a reviewer earlier when making changes in policy why we do need to again it after creating pull request
@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 👍
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
Ай бұрын
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?
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
Ай бұрын
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
Ай бұрын
@@LearnMicrosoftFabric thanks a lot for your answer! Yes, make sense!
Amazing Video!! I have one question: What is the correct order to work on Fabric?
@LearnMicrosoftFabric
Ай бұрын
Thanks! I'm not sure I understand your question... can you explain a bit more? 😊
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
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 👍
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
Ай бұрын
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)
Will, you smart
@LearnMicrosoftFabric
Ай бұрын
I'm not sure about that, but thanks 😂
HI Will, I didn't able to access the note from the link. it is blocked.
@LearnMicrosoftFabric
24 күн бұрын
I see you have now found the entrance, welcome!
@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
24 күн бұрын
@@souvanikchaudhury8890 You create the workspace, then go to Workspace Settings > Git integration
@souvanikchaudhury8890
23 күн бұрын
@@LearnMicrosoftFabric Got it! Thanks
✅
@LearnMicrosoftFabric
16 күн бұрын
Thanks for watching Carlos!