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.

How to refresh dataset using button in Report View of PowerBI?



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 the drill through option.

How to perform drillthrough action using button in Power BI?



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 action property of the button. Page Navigation in action property is available from Power BI March 2020 update. We have already explained it through an article, you can check it to know more about it.

Dynamic Multiple Column Selection in Power BI





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 do page navigation using a slicer and a button.

How to do Page Navigation using Slicer and a Button (without bookmark) in Power BI?

Power BI : How to get data from latest file in a folder in Power Query?



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 do we get data from the latest file in a folder in Power Query?  Check the below steps and you can practice with me in your machine. Create a dummy folder with various excel files and follow the steps which I have mentioned below.


 1. In Microsoft PowerBI Desktop, Click on Get Data >> Folder and click on the connect button at the bottom.


Power BI : How to get data from latest file in a folder in Power Query?



2. Input the folder path from where data from the latest file need to be brought in Power BI and click on the OK button. 


Power BI : How to get data from latest file in a folder in Power Query?


3. In the pop-up windows, click on the Transform button and then Power Query will get opened.



Power BI : How to get data from latest file in a folder in Power Query?



4.  In the Power Query, Sort the date column by clicking the down arrow at the right of the column name. Then sort the column in descending order.


Power BI : How to get data from latest file in a folder in Power Query?



5. Click on Reduce Rows Button and select Keep Top Rows and then Enter Keeps Rows as 1. 

Power BI : How to get data from latest file in a folder in Power Query?

      It will now show only the row having the date.

 6. Click on the double symbol on the right of the Content Column. 

Power BI : How to get data from latest file in a folder in Power Query?


7. Select the sheet having Data and click on the Ok button.


Power BI : How to get data from latest file in a folder in Power Query?


8. Now, You have data ready. It is optional to remove the Source. Name Column which shows the file name.

Power BI : How to get data from latest file in a folder in Power Query?


9. Click on Close and Apply button and get out of Power Query.

How to get data from latest file in a folder in PowerBI?


Final Thoughts

It was an easy task to get the data from the latest file from a folder. This scenario is applicable to servers where the middleware messaging solution like MQ has been implemented and lot of files use to come to a folder and we have a requirement to analyze the data of latest file.

I hope that the article was helpful to you. Please comment and let me know your feedback.





How to get data from latest file in a folder in PowerBI?




I recently worked upon a scenario where I have shown all the selected values in slicer in a Card. So, Card basically acts as a display screen which shows all the selected values in the slicer. The scenario which I just mentioned is very relevant and practical from reporting perspective with an intention to show selected values in a particular area of the report.

PowerBI : How to Display multiple selected values in a Card?




Microsoft Power BI is the most demanding analytics tool in the market. As per the Gartner`s Magic Quadrant for Analytics and Business Analytics Platform, Microsoft Power BI is the leader in the segment. You can check out the last 3 years ranking here.

With the increase in demand for the Power BI, people learning the tool in increasing exponentially. A lot of people are looking for books to learn Power BI. So let's see the best book for PowerBI.

The Best books for PowerBI is The Definitive Guide to DAX and Mastering Microsoft PowerBI. The Definitive Guide to DAX is the best book for learning DAX which is very essential to know while working on Microsoft PowerBI apart from that Mastering Microsoft PowerBI is a complete package that gives information about all the components related to PowerBI which is also essential and non-negotiable.

Apart from the two books mentioned above, there are some other books as well which are also very helpful in learning PowerBI.  So let`s check them out in the below list.

  • Microsoft Power BI Cookbook
  • Analyzing and Visualizing Data by Using Microsoft Power BI Exam Ref 70-778
  • Supercharge Power BI
  • Data Analysis with Microsoft Power BI.

So, let's review each of the books below in great detail:



Mastering Microsoft Power BI



Best Microsoft Power BI Books



Mastering Microsoft Power BI is a complete reference for learning powerbi. It gives you an overall knowledge of the product as a whole. It covers topics
  • Efficient data connectivity, retrieval, and data transformation using M Query.
  • Explains about Direct Query, Import Connection and Live Connection
  • Making rich and Interactive Dashboards and reports.
  • Make a complete on-premise solution with a Report Server.
  • Gateways  - On-premise Gateways and Personal Gateway.
  •  Creating apps and their distribution.
  • Managing Workspace
  • SSAS to Azure AS Migration
  • PowerBI Admin Portal 
  • DAX
Basically, This book covers all the topics which you need to master Microsoft Power BI. I recommend this book to a person who is interested to learn all the components associated with Microsoft Power BI. This book is a complete package.

Who wrote this book?

This book is written by Brett Powell who has also written a book Microsoft  PowerBI Cookbook which is also included in this list.

 How much does this Book Cost?

This book cost 71,55$. 


You can buy this book from Amazon by clicking on the link.



The Definitive Guide to DAX


Best Microsoft Power BI Books


The Definitive Guide to Dax is a great book for learning DAX Languages, which is essential for getting most out of Microsoft Power BI. Without DAX, You cannot bring good insight from your raw data. So DAX is an important language that you cannot skip learning, and to learn it, there is no better book than The Definitive Guide to DAX.


Who wrote this book?

Marco Russo and Alberto Ferrari have written the book. They are the owner of the SQLBI website and also some of the other sites like Daxformatter, Daxpattern, etc. Their work in the field of Microsoft technologies such as PowerBI, Excel, DAX is just outstanding. I have also mentioned about their Introduction to DAX Video Course in my article Best Resources to learn DAX.


How much does this Book Cost?

The book will cost you $53.12 for a new book and $52.13 the old book.

You can buy the book on Amazon by clicking the link here.



Microsoft Power BI Cookbook


Best Microsoft Power BI Books


Microsoft Power BI Cookbook is a great book for learning Power BI overall. This book has tips and tricks, practical use cases, technical recipes related to complete power bi platform including Power BI Service and Mobile Application.

In the book, you will get knowledge about Power Query, M language, Data Modelling, DAX Expression, Understanding the difference between Import, direct query, and live connection, how to publishing to power bi service, and schedule refresh, gateways, and its type. This book will cover all the components associated with Microsoft PowerBI.


Who wrote this book?

The book is written by Brett Powell who also owns Frontline Analytics and has previously worked with multiple analytics companies. He has written two books on Microsoft Power BI.

How much does this Book Cost?

The book costs approx 4.01$  but I found it worth buying to know about each and every component of Power BI in great detail.

You can buy this book on amazon by clicking the link.


Analyzing and Visualizing Data by Using Microsoft Power BI Exam Ref 70-778


Best Microsoft Power BI Books

The book is extremely useful for preparing Microsoft Certification Exam 70-778. Currently, Certification 70-778  has been deprecated by Microsoft. Instead of this exam, Microsoft launched the DA-100 Certification Exam which is currently in a beta stage.

I think it would be a great idea to start preparing for certification with this book and then move to another book because the topic included in this book will definitely be of importance in the DA-100 Exam.

Who wrote this book?

Daniil Maslyuk, MCSA, MCSE is a Microsoft business intelligence consultant who specializes in Power BI, Power Query, and Power Pivot; the DAX and M languages; and SQL Server and Azure Analysis Services tabular models. He is the author and founder of XXLBI.com.


How much does this Book Cost?

The book will cost 25.48$.

You can download the book from Amazon by clicking on the link here.


Supercharge Power BI: Power BI Is Better When You Learn to Write DAX


Supercharge Power BI is a great book for learning DAX. I found their approach to explaining concepts more practical. It's a great book for the beginner as each and every step is explained in the book with the help of a screenshot so that anyone can understand the concept easily.

I recommend you to please go through this book, you will definitely like it. To check the book`s initial pages, you can go to Amazon, click on Look Inside above the Image of the Book.


Best Microsoft Power BI Books

Who wrote this book?

This book is written by Matt Allington who also owns the Excelerator BI website which provides Online Courses related to PowerBI. I am a regular visitor to his site and always loved the blog posted by Matt. I suggest you read his blog and as well his book. 


How much does this Book Cost?

This book costs 19.39$.
You can also buy this book from Amazon by clicking here.


Data Analysis with Microsoft Power BI



Best Microsoft Power BI Books


What I loved about the book is the practical step by step approach of explaining a topic. This book has explained all the topics in a very easy language so that anyone can understand the topic very easily.

I would definitely recommend this book for someone who is looking for a book with an easy explanation.

The book has described Data loading, Data preparation, Data Modelling, and Visualization using various graphs and charts in a very practical manner using a screenshot from the Power BI Desktop.


Who wrote this book?

The book is written by Brian Larson is the chief creative officer and partner at Superior Consulting Service and also a frequent presenter at SQL Saturdays and Pass Summit. He is also a columnist at SQL Server Magazine. This book is published by McGraw Hill Education. 


How much does this Book Cost?

This book costs about  $51.62.

You can but the book from Amazon by clicking the link here.


Final Thoughts


I have written this article after much research and past experience. During the preparation phase of the article, I have gone through a lot of books related to Power BI but I have suggested only those books which provided valuable information and have explained the topic in an easy and step by manner for better understanding.









  


Best Microsoft Power BI Books





Today, I updated Microsoft Power BI on my machine and found something amazing which I would like to share with you. We always try very hard to make our Power BI Report look appealing and nice.

PowerBI : How to bring Shadow Effect in Visuals?