Power BI – 2021 previous versions

List of Power BI 2021 previous versions: Note: Due to WordPress.com storage limitation we moved Power BI installation files to SugarSync file storage. 2.88.1144.0 09 January 2021 32-bit Download 2.88.1144.0 09 January 2021 64-bit Download 2.88.1385.0 22 January 2021 32-bit Download 2.88.1385.0 22 January 2021 64-bit Download 2.88.1682.0 09 February 2021 32-bit Download 2.88.1682.0 09 … Continue reading Power BI – 2021 previous versions →

Power BI – 2020 previous versions

List of Power BI 2020 previous versions: Note: Due to WordPress.com storage limitation we moved Power BI installation files to SugarSync file storage. 2.78.5740.861 21 February 2020 32-bit Download 2.78.5740.861 21 February 2020 64-bit Download 2.79.5768.1082 01 April 2020 32-bit Download 2.79.5768.1082 01 April 2020 64-bit Download 2.79.5768.721 13 March 2020 32-bit Download 2.79.5768.721 13 March 2020 64-bit Download 2.80.5803.1061 05 May 2020 32-bit Download … Continue reading Power BI – 2020 previous versions →

Exam DA-100: Analyzing Data with Microsoft Power BI

Microsoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wondering why do I want to take the exam DA-100? What is the benefit of passing this exam? And then some … Continue reading Exam DA-100: Analyzing Data with Microsoft Power BI →

Power BI: How to format a specific cell or row in a table or matrix?

This week, I got an interesting question about Power BI: “Can I format a specific cell or row in a table or matrix?” My answer was yes and I thought it could be a great blog. Let’s say, you need to format the Sales Amount for all countries as a whole number, except for Australia. … Continue reading Power BI: How to format a specific cell or row in a table or matrix? →

What is SQLSaturday?

On this post, I will talk about SQLSaturday. I believe some people don't know what SQLSaturday is and I am so happy to explain it 😊 SQLSaturday is a free 1-day training event for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through … Continue reading What is SQLSaturday? →

Power BI Features Insights

Hi All, Power BI is a powerful tool to analyse data and share insights, that’s the reason this month I decided to create a quick Power BI report to show an insight of all releases since July 2015. I really enjoy working with Power BI and I appreciate how Microsoft Power BI Team listens to … Continue reading Power BI Features Insights →

3 Seconds of Fame & Experience at PASS Summit 2017

This year was my second year at PASS Summit and I can summarize these five days as inspiring, connecting, sharing and learning. I have been interviewed by PASS TV, where I had my 3 seconds of fame 😊 and it was a great experience to talk about this event. https://www.youtube.com/watch?v=JDx70lt2wBQ&feature=youtu.be If you have a chance … Continue reading 3 Seconds of Fame & Experience at PASS Summit 2017 →

Power BI – Importing Multiple Excel Sheets

Last week, I received an Excel file with hundreds of sheets and I had to import it to Power BI. The Excel spreadsheet had one sheet per day, as below: When I tried to import it, I realized that a lot of people may have the same requirement and I decided to write this post, … Continue reading Power BI – Importing Multiple Excel Sheets →

Power BI – Working with Date – Part II

In the previous post (Working with Date – Part I), I wrote about calculated column for month and year and in this post I will explain how to work with day and week formats. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part II →

Power BI – Working with Date – Part I

I have been working with Power BI for few years and quite often someone asks me questions about Date functions in DAX (Data Analysis Expressions), that is the reason I am writing this post. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part I →