I have passed the DP-200 exam on 28 Oct 2020. I have gone through the various study material and courses in order to prepare for the exam. Overall, the time taken by me for the DP-200 exam is approx 3 months. Ideally, you should not take 3 months of time but due to lack of guidance, I happen to take a number of online courses which was not required to be taken for passing the DP-200 Exam.
we will see how can we integrate a Power BI report in the Microsoft Teams application.
While going through the Microsoft Power BI Community, I saw a post where a fellow member was asking for a solution to the problem in getting the difference between the sum of values for the most recent date and Just the previous date. I worked to find a solution for the problem …
Difference between sum of values for recent date and 2nd most recent date. Read More »
While working on the scenario “How to refresh dataset using button in Report view of Power BI?”, We have added a DAX function UTCNOW() which will give the refresh time and date value in a card. But the value in the card will be in the UTC and we are more interested to show the …
How to convert UTC into Local Time Zone in Power BI Report using DAX? Read More »
You can add a button in your report which will refresh the data once you click on the refresh button in the report view. I have seen in various forums that this has been asked by many clients. For achieving this functionality we will use Microsoft Power Automate and also use Wrap API. I hope …
How to refresh dataset using button in Report View of PowerBI? Read More »
Drill-through is an option in power bi desktop using which we can drill through to a page having details with a specific context. After the March 2020 update, Drill through can be performed using the button as well, earlier the same task was performed by right-clicking on a context in a chart and then selecting …
How to perform drillthrough action using button in Power BI? Read More »
Power Automate is an RPA solution from Microsoft which is also part of the Power Platform. Microsoft Power Platform is a group of products i.e Power BI, Power Apps, Power Virtual Agent, and Power Automate. Microsoft Power Automate was earlier known as Microsoft Flow. Using power automate, a large number of business automation tasks can …
In this article, we will discuss dynamic multiple column selection using a slicer and a button in Microsoft Power BI. Here, we will use the new page navigation option which is provided the action property of the button. Page Navigation in action property is available from Power BI March 2020 update. We have already explained …
Page Navigation is an important part of the report as it makes the report more interactive. Previously, We used to achieve page navigation in a report using a bookmark and it was not possible to do the same using slicers and a button. After the March 2020 Power BI Update, It is possible to …
How to do Page Navigation using Slicer and a Button (without bookmark) in Power BI? Read More »
Working on data from the latest file in a folder is a very common requirement. I have been asked about it in one of the Company Interviews. Well, at that moment of time I was having no idea about it but later I got this as a requirement in one of my project requirements. So, How …
How to get data from latest file in a folder in PowerBI? Read More »