power query

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.

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

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

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

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…

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.

This is a quick tutorial on how to analyse M-functions step-by-step. Invoking a function will only get the results - see how to follow every single step.

Easy way to expand a complex JSON record without loosing the information that is visible already. Works for star schema and for big flat table

In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerfu…