power query

power query

962 bookmarks
Custom sorting
Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Recently I’ve been doing some more investigations into how data privacy settings work in Power BI. This is a subject I’ve blogged about in great detail already in a series of posts last year, but t…
·blog.crossjoin.co.uk·
Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Converting Multiple Items into One Row in Power Query
Converting Multiple Items into One Row in Power Query
I was working with some external data where I had a list of Australia postal codes, the challenge is that there are multiple suburbs that are part of one postal code. Below I am going to show you h…
·fourmoo.com·
Converting Multiple Items into One Row in Power Query
Power Query Advanced Editor keyboard shortcuts
Power Query Advanced Editor keyboard shortcuts
Here I am showing some keyboard shortcuts in the Advanced Editor of Power Query Editor in Power BI Desktop, as well as show how to enable a mini map!
·xxlbi.com·
Power Query Advanced Editor keyboard shortcuts
Power BI And Column Order In M Queries And Dataset Tables
Power BI And Column Order In M Queries And Dataset Tables
The order of the columns in a table in a Power BI dataset doesn’t matter all that much, especially because the Fields pane in Power BI Desktop ignores the original column order and lists the column…
·blog.crossjoin.co.uk·
Power BI And Column Order In M Queries And Dataset Tables
Load the Latest Version of a File in Power Query
Load the Latest Version of a File in Power Query
There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your Power BI reports. …
·exceleratorbi.com.au·
Load the Latest Version of a File in Power Query
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to obs…
·blog.crossjoin.co.uk·
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
Creating a Power Query function browser – #powerbi
Creating a Power Query function browser – #powerbi
One of the best functions in Power Query (M) is for sure the function =#shared that inside the Query editor lists all the functions in M and in your current pbix file. Picture 1 Result of =#shared But…
·eriksvensen.wordpress.com·
Creating a Power Query function browser – #powerbi
Export data from Power BI to csv using Python
Export data from Power BI to csv using Python
Export data from Power BI to csv -files is best done using Python. Check this article for hows and whys:
·thebiccountant.com·
Export data from Power BI to csv using Python
Merge Operations in Power BI / Power Query – Part 2: Right Outer Join
Merge Operations in Power BI / Power Query – Part 2: Right Outer Join
Facebook Twitter LinkedIn If you haven’t read Part 1 of this series, I highly recommend that you read that prior to this post. In that previous post, we went over the Left Outer Join and some basics on how Joins / Merge operations work inside Power Query / Power BI where the position of the …
·poweredsolutions.co·
Merge Operations in Power BI / Power Query – Part 2: Right Outer Join
Combine All Sheets in a Workbook with Power Query
Combine All Sheets in a Workbook with Power Query
There are quite a few different common business scenarios where you get data in the form of a file on a regular basis. The 3 common patterns I use most often are. Each day/month/year you get a new…
·exceleratorbi.com.au·
Combine All Sheets in a Workbook with Power Query
Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows
Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows
I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a qu…
·blog.crossjoin.co.uk·
Power BI Data Privacy Levels And Cloud /Web-Based Data Sources Or Dataflows
Writing data to GitHub using Power Query only
Writing data to GitHub using Power Query only
Using Power Query to write out data is usually a very bad idea. But I found an exeption where it made a lot of sense to me: Writing data to GitHub to feed..
·thebiccountant.com·
Writing data to GitHub using Power Query only
The Fill Down Hierarchies Challenge
The Fill Down Hierarchies Challenge
A weekend challenge I hope you are enjoying your second weekend of 2019. I was helping a friend recently figuring out the following data challenge: You have a table of Backlog items with three levels of hierarchies (Scenario, Feature and Backlog Item). In each row, the source data includes the unique ID of the lowest …
·datachant.com·
The Fill Down Hierarchies Challenge
Update your report based on a website
Update your report based on a website
A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you...
·kasperonbi.com·
Update your report based on a website
Bulk Find And Replace In Power Query
Bulk Find And Replace In Power Query
Learn how to do a bulk find and replace in power query based on a list of values.
·howtoexcel.org·
Bulk Find And Replace In Power Query
Power Query – Combining Columns in M
Power Query – Combining Columns in M
In my Power BI courses I always recommend some books and sites that will help them learn DAX or M. Most of the time i'm presenting to new users to Power BI, and having to get them to move from the Exc…
·jlsql.wordpress.com·
Power Query – Combining Columns in M
Excel.Workbook() And The delayTypes Option In Power Query/Power BI
Excel.Workbook() And The delayTypes Option In Power Query/Power BI
A while ago I found myself wondering – as I often do about this kind of thing – about what the undocumented third parameter of the Excel.Workbook() M function (called delayTypes) actually does. I f…
·blog.crossjoin.co.uk·
Excel.Workbook() And The delayTypes Option In Power Query/Power BI
Types in PowerQuery cannot be compared and a Type.AsText function
Types in PowerQuery cannot be compared and a Type.AsText function
While searching for a compact formula to retrieve the textual representations of a type in Power Query, I learned that a type comparison in Power Query will return unreliable results, as "Type equivalence is not defined in M". So I continue using my old function, which I'm sharing here as well.
·thebiccountant.com·
Types in PowerQuery cannot be compared and a Type.AsText function
Splitting Text By Character Transition In Power BI And Excel Power Query
Splitting Text By Character Transition In Power BI And Excel Power Query
The February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansber…
·blog.crossjoin.co.uk·
Splitting Text By Character Transition In Power BI And Excel Power Query
An Oldie but Goodie - PowerPivot In Excel: Existing Data Connections
An Oldie but Goodie - PowerPivot In Excel: Existing Data Connections
With the Power BI craze that kicked into high gear in 2017, it’s less common to be working in PowerPivot in Excel. However, during one of my recent remote consulting calls, one of our many clients needed some help with a solution created in PowerPivot in Excel. And I often find if ONE person needs help or has a
·powerpivotpro.com·
An Oldie but Goodie - PowerPivot In Excel: Existing Data Connections
Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
A new splitter function has been discovered in Power Query (by Chris Webb and also others probably) which is not in the highlight notes of the February 2019 PBI release, but it is a very nice addit…
·janizajcbi.com·
Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery
Thoughts On The New Power Query Source In SSIS
Thoughts On The New Power Query Source In SSIS
Yet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it…
·blog.crossjoin.co.uk·
Thoughts On The New Power Query Source In SSIS
Create a Power Query custom data connector in 10 minutes
Create a Power Query custom data connector in 10 minutes
Getting set up When I heard about custom data connectors for Power Query, I had assumed there would be a lot of work involved. While there is definitely quite a bit of work in implementing advanced fe…
·sqlgene.com·
Create a Power Query custom data connector in 10 minutes