RADACAD Data Analytics Updates 10th Apr 2025

Best way to Combine files in Power BI or Fabric using Power Query

When you have multiple files in the same folder (regardless of the type of files, Excel, CSV, TEXT, or anything) and you want to automate the process of combining them without opening Power BI each time and populating the new data, there is a good way to do it in Power Query. In this video, I showed you how the Combine files feature works in Power Query, which is also available in Excel, Power BI Desktop, Dataflow, and Power Query online inside Microsoft Fabric. I also explained the tips and tricks for working with the custom function to customize the transformation and how to filter the data before combining it.

Find mismatch rows in Power BI and Power Query

Finding rows that are in one table, but not the other is one of the most common scenarios happening in any data related applications. You may have customer records coming from two sources, and want to find data rows that exist in one, but not the other. In Power Query, you can use Merge to combine data tables together. Merge can be also used for finding mismatch records. You will learn through this video, how in Power Query you can find out which records are missing with Merge, and then report it in Power BI.

In-Person Fabric and Power BI Courses: The World Tour 2024 has ended, and 2025 dates announced: early bird sales closing for Europe

We have announced the dates and cities for the in-person RADACAD courses in North America, Europe, Australia, and New Zealand.
Last year, the tour was in 17 cities, and we got fantastic feedback from attendees.
This year's tour includes Power BI and Fabric training, and we look forward to seeing you there.

Seats are limited. We want you to take advantage of this opportunity to learn the cutting-edge technologies of Microsoft Power BI and Fabric and use them to step up your career ladder.
Reza developed the training content for courses in the Rookie to Rock Star format (similar to our popular Power BI courses). These are in-person training sessions.
We are looking forward to welcoming you all to this course.

Course: Microsoft Fabric; From Rookie to Rock Star (3-days)

Chicago, Nov 3-5
New York, Nov 10-12
London, June 23-25 (early-bird closing soon)
Auckland, Jul 21-23
Sydney, Aug 18-20

Course: Microsoft Fabric; From Rookie to Rock Star (3-days)

Miami, Nov 24-26
Zurich, June 16-18 (early-bird closing soon)
Melbourne, Aug 11-13

Here are some feedback from this round of training;

Enthusiastic and intense, it’s been an incredible three days, covering all important aspects of Data engineering, Data warehousing, Integration, Data governance, and Fabric best practices. From hands-on lab exercises to ad hoc discussions, we’ve dived deep and explored every facet of the Fabric landscape.
The course was very helpful to deepen more into the Power BI capabilities and its use cases, seeing different solution alternatives, and strengthen the knowledge we already have in some topics.
I liked the training a lot. It was a very interactive session - good level of overview around PowerBI Architectures, mixed with right level of deeper dives. Reza was always open and approachable to adjust the agenda and answering questions relevant to the audience. I enjoyed switching between presentation and Live-demos, which made the content easy to understand and remember.
Reza is very knowledgeable in MS tech stack and some of the questions he answered went beyond just the fabric usage in a more holistic and practical view from his experiences. It was one of the best engaging trainings I have attended in years and would definitely recommend anyone looking to learn Fabric architecture and workloads to attend this brilliantly designed course.
I thoroughly enjoyed the Microsoft Fabric training. The content was well-structured and relevant, providing a deep dive into essential topics. Reza was an outstanding trainer, whose enthusiasm and deep knowledge made the learning process both effective and enjoyable. His practical examples and hands-on approach greatly aided in understanding the complexities of Fabric. I leave this course better equipped and confident in applying these new skills in my work. Highly recommend!
I really enjoyed the training. I learned a lot. Reza has the ability to convey information well and takes the time for questions.
The course was quite informative and filled up gaps in understanding MS Fabric platform. Now we have clearer strategy what is the best way to use the platform.
Thank you! Great job!

A list of all upcoming events is available here.

Here are some photos from last year's training tour;

Difinity Conference, In person, Nov and Dec, Australia and New Zealand

Difinity is the largest Microsoft Data, AI, Power BI, and Fabric Conference in New Zealand and Australia, focusing on Microsoft Fabric and Data and AI technologies of Microsoft. IT Decision Makers, Developers, Business Analysts, IT Professionals, Data Engineers, Data modelers, ETL developers, Data Architects, BI Managers, BI Professionals, Database Administrators, Architects, Digital & Big Data business leaders, and Consultants will gather for two consecutive days of learning.

We are pleased to have successfully run Difinity in these two cities with the great support of our speakers. The dates for the next year will be announced soon.

Auckland: https://difinity.co.nz/
Sydney: https://analyticsconfsydney.azurewebsites.net/

In Loving Memory of Leila Etaati

Leila Etaati is a name that RADACAD started, grew, and matured with it. She was the heart and brain of RADACAD. It is with great sadness that she passed away on the morning of 31st of December 2023 after 11 months of nonstop fight with progressive head and neck cancer. Leila was co-founder and co-director of RADACAD, Power BI & Fabric Summit, Difinity conference, Data Insight Summit, SQL Saturday Auckland, Power BI and Analytics user group in Auckland, and Global AI BootCamp in Auckland.
Some of the videos and articles published in 2023 were done while Leila was either at the hospital or going through difficult treatment plans. Nothing has ever stopped Leila from doing her work, which she loved and wanted to help community at the same time.
The past few months were split into two parts: the part that she was battling deadly cancer with all her might, I have been with her at the hospital, and we never really had much chance to think about work and our newsletter. And after her passing, which was not less difficult for me to keep going.
I may write about her difficult path in the last few months of her life at some stage, it is the most unbelievable and sad story, but also shows how strong Leila was facing all of those in a situation that everyone else would have lost hope.
I have written a tribute to her which is also mentioned in her Eulogy, which you can read here.
Below is also the video of her funeral. Leila is always with RADACAD.

Reza

Consulting Support Calls with RADACAD Team

Get on a one-on-one call with one of our consultants, and get your problem fixed as soon as possible. On a monthly subscription, we can cover all your questions. Choose what is the best package for your monthly support subscription. Hours to be used within 30 days (one month). You can cancel anytime, No long term contract. Contact us if you have any questions.

https://learn.radacad.com/product/consulting-support-calls-power-bi-and-ai/