To be honest I have never seen like this video before as well as like this teacher, I don't have words to express my happiness and how to say thank you
Hi, This is an excellent video on Power BI Deployment Pipelines. After watching the video I got curious and started exploring implementing Deployment Pipelines in my project. Couple of questions - 1) Can we assign an existing Prod workspace to a deployment pipeline, similarly can we change a workspace to assign it to a different workspace? 2) Can we configure dataset rules for data source as SQL Server on Amazon RDS Also, could you please upload a video on auto-sync of content with SharePoint, OneDrive etc. and how this feature enables version control within deployment pipelines. Thanks for uploading this video, very informative.
Hi, thanks for your comment. Let's start with the first question. 1) You can assign only premium capacity based workspaces to pipelines. So, whenever you are creating a new deployment pipeline, if you have already created a Prod Workspace on Premium Capacity, you can assign it. 2) Yes, we can add Dataset Rules for SQL Server. However, personally, I haven't tried on Amazon RDS. 3) I'll upload a video for auto-sync.
Very Nice explanation. Thanks much. After searching over UA-cam for half day, i find yours. Very useful. But the deployment sages are all manual. Can we automate and authorize the deployments ?
Can i ask you a vey basic question? What is the benefit for having a deployment pipelines over conventional way of creating workspace and publish the dashboards??
Well, conventionally, if you will deploy your reports or publish your reports to different environments, you won't get to know the changes you made in the report. However, once you will use deployment pipelines, it would show you the difference between new and the existing files. Then, depending on your requirements, you can proceed further or stop.
if you are deploying a new report, will you use the existing pipeline or you can create a new pipeline. I created a new separate pipeline but I was not able to access any workspace to it because the old pipepline was assigned to the existing workspace. hence I had to use the existing pipeline and I had to re-published already existing report and the new report together to the app
Thanks for your comment. Please note that we don't create new pipelines for each report; instead, we use one pipeline for an entire domain or department. When setting up a deployment pipeline, you must assign workspaces to it, otherwise it won't function properly. Before using any deployment pipeline, ensure that your reports are already published in the associated workspace. You can then move reports between workspaces using the deployment pipeline. Ideally, you should set up Dev, Test, and Production workspaces. Initially, publish your report to the Dev workspace. Once it's ready, use the deployment pipeline to move it from Dev to Test/Acceptance, and then to the Production workspace. Currently, you can create up to 10 stages in a deployment pipeline, depending on your needs.
If someone want to learn for free about Power BI this is the one an only one plateform to build career absolutely free. Sir are doing very well definitely God gives you more and more happiness and prosperity. Thanks a Trillion and Trillion.
Hi, in simple terms, when we need to move reports from one environment or workspaces, then we need them. Also, to use then we need Power BI Premium or Premium Per User License
Suppose our team implements a deployment pipeline, but later down the line we change our mind and want to revert back to managing separate workspaces. Is it possible to take the workspaces &/or reports out of the pipelines?
Deployment pipelines are basically to put a check or version system. So that you can get to know what you are publishing. Also, you will get to know what is the difference between production version and the version you are trying to deploy.
@@BIConsultingPro great so powerbi developer role is extraction of data from DB and preparing the visuals as per the client req and publishing to the assigned workspace am i right ? Who will do the deployment pipelines any QA or testing team or developer will do ?
@@kiran4059 one power bi report has many parts. For example, data sets, measures, report visualizations, layout, RLS, etc. if you are talking about who is going to deploy all this, That depends from company to company. Generally, the Power BI report developer does that.
Hi, great post. Very clear and consise. What happens if my report in Dev is using Dataflows - can we still migrate that report to Test and then Prod? Or does the deployment pipeline only work with datasets?
Hi, I have gone through your videos and these are indeed amazing. I am in process of learning. And had one query. I have prepared the reports in power bi desktop from the data which is extracted from ms Excel file. I have published that report using services. However, I am unable to refresh the dashboard now. What could be the possible reason. I think it is related to gateway. Secondly. One of my important questions is once I publish the report in power bi, then the data set is also there in power bi services. So how my raw data( data in Excel at desktops) , my power bi desktop file(developed report in power bi) and data set in power bi services are related. What if I delete the file of desktop. what are the repercussion? I mean in order to update the dashboard, do we need to update the excel file first or what is the appropriate way. Thank you
Hi Kamal, thanks for your question. Yes, it's related to the data gateway. Since there is no link between your desktop file (MS Excel) and Power BI Service (Web), so you won't be able to refresh the data or schedule refresh. Secondly, the easiest solution is to put your file on SharePoint and connect from there. Then you don't need any data gateway to connect. You just need to authenticate yourself. Check this video: ua-cam.com/video/xaPOoBUqeYs/v-deo.html Also, you can put your file on OneDerive if you don't have SharePoint access. Now, let me answer, another part of your question. Once you import data in Power BI, then you have your data extract in Power BI. Data would always be in Power BI and you can create reports etc. However, if you are on Power BI Desktop and the file is also on your desktop or cloud, you can go to "Data Transform Tab" and can make changes using Power Query/Power Pivot. If you would make any change in the excel file and refresh the data in Power BI, changes would reflect, if you would delete the file, you won't be able to refresh the data or make any changes as now the File doesn't exist. Similarly, if your file is on the cloud (like SharePoint or OneDerive), you can refresh the data after entering your credential on Power BI Service but if you will delete the file, data would be there which you loaded initially but you won't be able to make any data refresh as refresh would get fail.
Thank you @BI Consulting pro, very well explained. Always appreciate your work and method of teaching in all your videos. One final question. My end goal is to pass the certification as early as possible and the way you explain, I believe all what we need for DA-100 will be covered in your videos. However, Could you please suggest any book(if any) to improve my knowledge in fast pace and clear the exam? Finally, How many videos will be there from your end for this Da-100 exam playlist so that I can prepare myself accordingly. An early response from your end is appreciated.
@@KamalKumar-fl2zb Thank you for your comment. Microsoft Documents are enough for theoretical knowledge but if you still wants to go for the book, then please find the following link: www.microsoftpressstore.com/store/exam-ref-da-100-analyzing-data-with-microsoft-power-9780136819684 Also, coming Saturday, I'll publish the last video which would be on RLS.
Thank you. I believe this book is yet to be released and will be released in May 2021. Any other suggestion/book that you can share. Thank you for sharing the knowledge. The video uploaded by you on RLS is indeed worth spending time on.
No. It was just released. the MS Learn path should be sufficient. - it's a comment from MS Employee. So, for now, I'll suggest keep the focus on the Microsoft learning path and later use this book! Go to this link and at the bottom you will find learning path: docs.microsoft.com/en-us/learn/certifications/exams/da-100
How to change data source for paginated reports after deploying to test region??? Even after creating rule it’s not changing, it is showing only dev connections. Can you please help here
Have you parametrise your report? You need to do it for data source and other parameters to highlight the options. After that you can paste the Test Connection under Test Deployment rules
I have a report that is connected to a shared dataset in the workspace, but when I deploy the report forwards it stays connected to the dataset in the development workspace. This causes permissions and view issues because the people who have access to the production workspace don't have access to the development workspace. I've seen others use parameters for having reports connect to different DBs across the stages but how does it work with datasets?
Always remember that a user always needs an access to dataset in order to view the report! You can try either publishing this report in an app or grant user view access on the dataset
@@BIConsultingPro Sorry I should rephrase my question. Can you show how to make a report change which dataset it is connected to across deployments? I.e. Report in dev uses directquery again the dataset in dev, the report in test used Direct query against the dataset in test, and the report in production uses the production dataset.
Hi. Good information. I have one question. How to restrict the data between environments, I mean from dev need to move only report not data. How we can handle?
Well, When you deploy content from one pipeline stage to another, the copied content contains the following Power BI items: Datasets Reports Dashboards Paginated reports You cannot deploy them separately.
However, you can separate your dataset and report and then can do the deployment. Note the following: The first thing that I want to mention it is always recommended to separate the dataset and report. You might be thinking why the separation? Some of the reasons are: People curating and updating the dataset can do this independently. People creating reports and dashboards can create this independently. Quicker and easier deployment of changes to datasets without affecting the reports. Reports can be updated without having to rely on dataset updates.
I got my answer in your comment, thanks. if you will deploy your reports or publish your reports to different environments, you won't get to know the changes you made in the report. However, once you will use deployment pipelines, it would show you the difference between new and the existing files. Then, depending on your requirements, you can proceed further or stop.
Please watch again. These are to deploy code between different environments. The first code should be developed in DEV, then for testing, it goes to Test Environment, and finally, if it's good, it goes to the production environment. Deployment pipelines makes this process easy, and you can find the difference between different environment codes or files before deploying.
If you have any questions or feedback, kindly let us know!
To be honest I have never seen like this video before as well as like this teacher,
I don't have words to express my happiness and how to say thank you
Thank you for your kind words!! We’ll keep it up and will try our best.
Hi,
This is an excellent video on Power BI Deployment Pipelines. After watching the video I got curious and started exploring implementing Deployment Pipelines in my project.
Couple of questions -
1) Can we assign an existing Prod workspace to a deployment pipeline, similarly can we change a workspace to assign it to a different workspace?
2) Can we configure dataset rules for data source as SQL Server on Amazon RDS
Also, could you please upload a video on auto-sync of content with SharePoint, OneDrive etc. and how this feature enables version control within deployment pipelines.
Thanks for uploading this video, very informative.
Hi, thanks for your comment.
Let's start with the first question.
1) You can assign only premium capacity based workspaces to pipelines. So, whenever you are creating a new deployment pipeline, if you have already created a Prod Workspace on Premium Capacity, you can assign it.
2) Yes, we can add Dataset Rules for SQL Server. However, personally, I haven't tried on Amazon RDS.
3) I'll upload a video for auto-sync.
Excellent Work. Thanks. One Side question, can you please share the link of the music which is being played in the background. Loved it as well.
Great explanation! Easy to understand. Thank you! :)
ur all videos are very helpful
thanks a lot.
thanks for your feedback.
Very Nice explanation. Thanks much. After searching over UA-cam for half day, i find yours. Very useful. But the deployment sages are all manual. Can we automate and authorize the deployments ?
Well, not as of now but in the future you can! You can also use ALM Toolkit for the deployment.
Finished watching
amazing.. keep learning and keep exploring the world of data !
Can i ask you a vey basic question? What is the benefit for having a deployment pipelines over conventional way of creating workspace and publish the dashboards??
Well, conventionally, if you will deploy your reports or publish your reports to different environments, you won't get to know the changes you made in the report. However, once you will use deployment pipelines, it would show you the difference between new and the existing files. Then, depending on your requirements, you can proceed further or stop.
if you are deploying a new report, will you use the existing pipeline or you can create a new pipeline. I created a new separate pipeline but I was not able to access any workspace to it because the old pipepline was assigned to the existing workspace. hence I had to use the existing pipeline and I had to re-published already existing report and the new report together to the app
Thanks for your comment. Please note that we don't create new pipelines for each report; instead, we use one pipeline for an entire domain or department.
When setting up a deployment pipeline, you must assign workspaces to it, otherwise it won't function properly.
Before using any deployment pipeline, ensure that your reports are already published in the associated workspace. You can then move reports between workspaces using the deployment pipeline.
Ideally, you should set up Dev, Test, and Production workspaces. Initially, publish your report to the Dev workspace. Once it's ready, use the deployment pipeline to move it from Dev to Test/Acceptance, and then to the Production workspace.
Currently, you can create up to 10 stages in a deployment pipeline, depending on your needs.
If someone want to learn for free about Power BI this is the one an only one plateform to build career absolutely free.
Sir are doing very well definitely God gives you more and more happiness and prosperity. Thanks a Trillion and Trillion.
Thank you for your kind words!! We’ll keep it up and will try our best.
Is this for data analysis, such as regular reporting building and publishing or is it for software engineers?? what is this for in layman terms
Hi, in simple terms, when we need to move reports from one environment or workspaces, then we need them.
Also, to use then we need Power BI Premium or Premium Per User License
The Data Source Rule is not getting enabled for me
Suppose our team implements a deployment pipeline, but later down the line we change our mind and want to revert back to managing separate workspaces. Is it possible to take the workspaces &/or reports out of the pipelines?
You can simply delete the deployment pipeline. This won't affect your workspaces.
Please what is the relation between level of maturity and type of deployment ?
Thank you for your feedback. Could you please elaborate a bit more? Are you talking about dataset maturity or Power BI Maturity in the organization?
Small Question if dev data source and Test data source and Credentials is different is it possible to deploy report to deployment pipeline
Try to use parameters for your connections.
Awesome. Thanks
I have a ques may i know wat happens after the production..i mean to wat is output and purpose of doing this deployment pipelines.
Deployment pipelines are basically to put a check or version system. So that you can get to know what you are publishing. Also, you will get to know what is the difference between production version and the version you are trying to deploy.
@@BIConsultingPro great so powerbi developer role is extraction of data from DB and preparing the visuals as per the client req and publishing to the assigned workspace am i right ?
Who will do the deployment pipelines any QA or testing team or developer will do ?
@@kiran4059 one power bi report has many parts. For example, data sets, measures, report visualizations, layout, RLS, etc.
if you are talking about who is going to deploy all this, That depends from company to company. Generally, the Power BI report developer does that.
@@BIConsultingPro there wont be any testing team to deploy ?
Hi Is it possible to have one on one online sessions if you are a member?
Yes, for 15 minutes
@@BIConsultingPro Okay thanks
Excellent content, thank you
Glad you enjoyed it!
i have made changes and deployed to production can i restore previous version?
Hi, great post. Very clear and consise. What happens if my report in Dev is using Dataflows - can we still migrate that report to Test and then Prod? Or does the deployment pipeline only work with datasets?
Yes, you can. For more info: docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/power-bi/power-bi-dataflows-deployment-pipelines
Hi, I have gone through your videos and these are indeed amazing. I am in process of learning. And had one query. I have prepared the reports in power bi desktop from the data which is extracted from ms Excel file. I have published that report using services. However, I am unable to refresh the dashboard now. What could be the possible reason. I think it is related to gateway. Secondly. One of my important questions is once I publish the report in power bi, then the data set is also there in power bi services. So how my raw data( data in Excel at desktops) , my power bi desktop file(developed report in power bi) and data set in power bi services are related. What if I delete the file of desktop. what are the repercussion? I mean in order to update the dashboard, do we need to update the excel file first or what is the appropriate way. Thank you
Hi Kamal, thanks for your question.
Yes, it's related to the data gateway. Since there is no link between your desktop file (MS Excel) and Power BI Service (Web), so you won't be able to refresh the data or schedule refresh.
Secondly, the easiest solution is to put your file on SharePoint and connect from there. Then you don't need any data gateway to connect. You just need to authenticate yourself. Check this video:
ua-cam.com/video/xaPOoBUqeYs/v-deo.html
Also, you can put your file on OneDerive if you don't have SharePoint access.
Now, let me answer, another part of your question.
Once you import data in Power BI, then you have your data extract in Power BI. Data would always be in Power BI and you can create reports etc. However, if you are on Power BI Desktop and the file is also on your desktop or cloud, you can go to "Data Transform Tab" and can make changes using Power Query/Power Pivot. If you would make any change in the excel file and refresh the data in Power BI, changes would reflect, if you would delete the file, you won't be able to refresh the data or make any changes as now the File doesn't exist. Similarly, if your file is on the cloud (like SharePoint or OneDerive), you can refresh the data after entering your credential on Power BI Service but if you will delete the file, data would be there which you loaded initially but you won't be able to make any data refresh as refresh would get fail.
Thank you @BI Consulting pro, very well explained. Always appreciate your work and method of teaching in all your videos. One final question. My end goal is to pass the certification as early as possible and the way you explain, I believe all what we need for DA-100 will be covered in your videos.
However, Could you please suggest any book(if any) to improve my knowledge in fast pace and
clear the exam?
Finally, How many videos will be there from your end for this Da-100 exam playlist so that I can prepare myself accordingly. An early response from your end is appreciated.
@@KamalKumar-fl2zb Thank you for your comment. Microsoft Documents are enough for theoretical knowledge but if you still wants to go for the book, then please find the following link:
www.microsoftpressstore.com/store/exam-ref-da-100-analyzing-data-with-microsoft-power-9780136819684
Also, coming Saturday, I'll publish the last video which would be on RLS.
Thank you. I believe this book is yet to be released and will be released in May 2021. Any other suggestion/book that you can share. Thank you for sharing the knowledge. The video uploaded by you on RLS is indeed worth spending time on.
No. It was just released. the MS Learn path should be sufficient. - it's a comment from MS Employee. So, for now, I'll suggest keep the focus on the Microsoft learning path and later use this book!
Go to this link and at the bottom you will find learning path:
docs.microsoft.com/en-us/learn/certifications/exams/da-100
getting error while setting up gateway for dataflow for 2 different environment, dev and test, it's breaking
Is this feature in Powerbi similar to Promotion Management in Business objects?
Unfortunately, I don't have answer for this question as I haven't work on SAP.
How to change data source for paginated reports after deploying to test region??? Even after creating rule it’s not changing, it is showing only dev connections. Can you please help here
Have you parametrise your report? You need to do it for data source and other parameters to highlight the options.
After that you can paste the Test Connection under Test Deployment rules
@@BIConsultingPro Thanks for the reply! I'm new to this mate.. if you dont mind can you provide any document to refer.
@@akhilvulli learn.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-create-rules
@@BIConsultingPro Thanks alot
I have a report that is connected to a shared dataset in the workspace, but when I deploy the report forwards it stays connected to the dataset in the development workspace. This causes permissions and view issues because the people who have access to the production workspace don't have access to the development workspace. I've seen others use parameters for having reports connect to different DBs across the stages but how does it work with datasets?
Always remember that a user always needs an access to dataset in order to view the report! You can try either publishing this report in an app or grant user view access on the dataset
@@BIConsultingPro Sorry I should rephrase my question. Can you show how to make a report change which dataset it is connected to across deployments? I.e. Report in dev uses directquery again the dataset in dev, the report in test used Direct query against the dataset in test, and the report in production uses the production dataset.
Hi. Good information. I have one question. How to restrict the data between environments, I mean from dev need to move only report not data. How we can handle?
Well, When you deploy content from one pipeline stage to another, the copied content contains the following Power BI items:
Datasets
Reports
Dashboards
Paginated reports
You cannot deploy them separately.
However, you can separate your dataset and report and then can do the deployment. Note the following:
The first thing that I want to mention it is always recommended to separate the dataset and report.
You might be thinking why the separation?
Some of the reasons are:
People curating and updating the dataset can do this independently.
People creating reports and dashboards can create this independently.
Quicker and easier deployment of changes to datasets without affecting the reports.
Reports can be updated without having to rely on dataset updates.
Thank you for giving great content. I have one more question
I have 3 quantitative measures which visual I need take for this requirement
@@ankithsimha9073 Are they KPI or what?
@@BIConsultingPro In one interview they asked. How to show 3 measures in one visual. Which one is suitable?
has anyone explored CICD for apps
Pls delete backg music
Hi looking for job bi. ..3 years experience
I have any interview is thier please let me know ...
There is a group on Telegram "Power BI Professionals". Please join the group and you will get what you are looking for.
Hi I watched complete video and i did not understand actually use of deployment pipeline.
I got my answer in your comment, thanks. if you will deploy your reports or publish your reports to different environments, you won't get to know the changes you made in the report. However, once you will use deployment pipelines, it would show you the difference between new and the existing files. Then, depending on your requirements, you can proceed further or stop.
Please watch again. These are to deploy code between different environments. The first code should be developed in DEV, then for testing, it goes to Test Environment, and finally, if it's good, it goes to the production environment. Deployment pipelines makes this process easy, and you can find the difference between different environment codes or files before deploying.
Sir please make this video in hindi if posible
Hi I passed da100
Awesome! I am proud of you 😃😃