Power Query

Yesterday I've found a very awesome feature in Power Query (Thanks to Matt Masson). The feature is: you can see list of all functions in the Power Query with enumerations and option types with a

Every time there

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server

Satalyst BI Specialist: How to use Power Query and M to create a parameterized function and execute it against a list

Editor’s note: The following post was written by SQL Server MVP Rafael Salas Creating Power Query Functions You have seen or started using Power Query for Excel by now. If not you have been missing one of the greatest tools of the new Self-Service Business Intelligence offering Power BI. Power Query has a wide range...

By Julie Smith I was happy to co-present a session at this week’s Atlanta BI User Group with Rob Volk (@SQL_R) meeting entitled “Harvesting XML Data from the Web with Power Query and Cu…

Getting Started and Understanding Power Query and its M Language

Power Query transformations can be very powerful, but they only work on one data source at a time. Sometimes data providers will only provide their data in discrete chunks, like one category per ta…

If you've been using Power BI or you've seen the demos, then like me, you're probably excited about Power Query. As a data nerd, I've been having a lot of

letParamSource = GAIDs[Content],RaramRow = Table.SelectRows(ParamSource,each([Parameter]=ParameterName)),Value=if Table.isEmpty(ParamRow)=truethen nullelse Record.Field(ParamRow{0},"Value"),inValueletSolutionPath = fnGetParameter("File Path"), Source = Folder.Files(SolutionPath & "Data"),#"Combined Binaries" = Binary.Combine(Source[Content]),#"Imported CSV" = Csv.Document(#"Combined Binaries",null,",",null,1252),#"First Row as Header" = Table.PromoteHeaders(#"Imported CSV")in#"First Row as Header"

If there’s one feature of Power Query that’s guaranteed to get Excel users very, very excited indeed it’s the ability to combine data from multiple workbooks into a single table. The bad news is th…

A great question come up on the Power Query forum: “I would like to know if there is a way to pass parameters to a Stored Procedure used within a Power Query.” Here are the steps in det…

Power BI designer is based upon the Power Query formula language informally known as

I got a question on the blog recently about creating a banding function in Power Query, or creating buckets for Accounts Receivable transactions.  (30-60 days, 60-90 days, etc..)  As this is something that can be applied to a lot of … Continue reading →

Better way to use parameter tables in Power Query and Power BI: Easier to use and futureproof/robust. Transpose the table and your parameter names equal the

The April 2016 Power Query Update was just released for Office 365 subscribers, and I can confirm that it is available to the First Release customers, as I’ve already got it installed.  (If you’re on a later branch it may … Continue reading →

"Do we use Power Pivot or Power Query?" – I get this question all the time when teaching Power BI classes. (Note: This applies in Excel as well as Power BI

pquery - A collection of functions for use in Excel Power Query

This article shows you how to create dynamic data sources using Power BI query parameters. You also learn how to use query parameters in Filter Rows.

In this article we will look at multi condition logic in Power Query, exploring a scenario where we need to choose between several options.

Technical articles, content and resources for IT Professionals working in Microsoft technologies

While I was at the PASS BA conference in San Jose, CA last week, I got an email from a reader asking if Power Query could create a Cartesian Product join. Now I’m an Excel guy, and I’d never heard … Continue reading →

There are three options:   There are two ways to write a measure that returns the most recent date / processing date in your data model.   1. If you have a data(transaction) table Most Recent Transaction = CALCULATE( MAX(Transactions[Date]), ALL(Transactions) ) 2. If you have a calendar table - ther...

In a year’s time there will be a great opportunity for someone to present a session on “Power BI Development Best Practices” at the PASS Summit. Before then, we will all have to work out what those…

I saw an interesting post the other day on the Power Query Technet forum which showed how the List.Buffer() function could be used to improve calculation performance. This is something I’d seen hin…

One very common requirement when creating a Power BI report is the ability to apply a filter for the current day, week, month, quarter or year. There are several ways of implementing this: you coul…