In this blog we will learn about What is a Record, Extracting Records from a Table, Creating Records from Scratch. Also, there are two practical Examples of using Records that might be helpful in many different ways!

Get the equivalent of Excels FV function to calculate the future value of a series of payments for Power Query as well.

Get the equivalent of Excels PV function to calculate the present value of a series of payments for Power Query as well.

Improve performance and gain more control over your SharePoint data in Power BI by using the SharePoint API.

Blogging about Power BI, Power Platform and other things I find interesting.

Learn how you can quickly circumvent the dreaded Formula.Firewall issue in Power Query without having to rework all your queries

Have you ever wanted to extract information from a web page to use in a calculation, or as a reference for something else you may be working on? I have used similar functions in the past (pre Power …

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: There are code samples here: And guess what, t…

Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? How big is “big” anyway? These are questions you may have when y…

One of the most popular topics I’ve ever written about here is the dataset refresh errors you get with dynamic data sources and the Web.Contents function in Power BI (see here and here for ex…

Configure the API authentication to retrieve the token and return required data in Power Query

This content applies to: Power Query online Power Query desktop You may have noticed a new M function was added to Power Query recently: Web.Headers. This function allows you to make HEAD requests to web services – the existing Web.Contents function, which it resembles closely, only allows you to make GET and POST requests. You […]

In this post, we will learn about 'each' & 'Underscore _' in Power Query. We will also know how we can use them with Table & List!

how you can remove unwanted spaces from your data in Power Query. We will be also know about building custom functions & also working with it.

Guidance on how to create Power BI data models for Dataverse, PowerApps, and Dynamics 365.

New MSFT Guidance: Power BI for Dataverse. - I've documented the keys to performance and usability with #PowerBI reporting over Dynamics 365 CE or Model-Driven... 20 comments on LinkedIn

Did you know there are a lot of keyboard shortcuts for the advanced editor in Power Query that can save you time?

Occasionally you need to change to point to a different tenancy which means changing a connector to switch Dataverse tenancy.

The October release of PowerBI Desktop introduced a very interesting feature, Top N filtered is pushed down for Direct Query Sources, I thought I may give it a try and blog about it, for some reaso…

Learn the difference between DirectQuery mode and Live connections in Power BI

This step-by-step blog walks you through how to load large datasets in Power BI Desktop using parameters.

In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

Unpack all the new automation and functionality of Data Source, phData's newest tool from its Toolkit that helps with migration validation.