PQFL - Excelerator BI

PQFL

Best Book for Learning the M Language

Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; …

Best Book for Learning the M Language Read More

Build a Reusable Calendar Table with Power Query

I wrote a blog on this topic a few years ago over at PowerPivotPro.com.  I have learnt a lot about Power Query since that time, plus Power Query has come along in leaps and bounds, …

Build a Reusable Calendar Table with Power Query Read More

Use Power Query to Compare Database Records

Level: Intermediate I was helping a user on http://community.powerbi.com this week. The user had a list of service desk tickets for multiple customers and the requirement was to identify when a customer opened a second new …

Use Power Query to Compare Database Records Read More

Import Tabular Data from PDF using Power Query

Level: Intermediate [Edit: Sept 2018] Microsoft released the preview version of the PDF Connector in Power BI. This is another instance to show that Microsoft is listening to the community to add or improve the Power …

Import Tabular Data from PDF using Power Query Read More

Find Duplicate Files on Your PC with Power BI

Level: Beginners If you want to learn new skills using a new tool, then you simply must practice.  One great way to practice is to weave the new tool into you daily problem solving.  If …

Find Duplicate Files on Your PC with Power BI Read More

Scroll to Top