top of page
All Posts


We are hiring! Senior Power BI Consultant required
Datalineo are seeking a Senior Power BI Consultant to join the growing team. The ideal candidate is a Microsoft data platform expert with...
Ben Watt
May 31, 20211 min read
Â
Â
Â


Video: Evolving your Power BI Architecture with Dataflows and Shared Datasets
In February 2021 at the Scottish Summit, I spoke about Dataflows & Shared Datasets and how you can evolve your Power BI architecture...
Ben Watt
Apr 2, 20211 min read
Â
Â
Â


Parquet and CSV: Querying & Processing in Power BI
The ability to load data from Parquet files into Power BI is a relatively new thing and given it's storage structure, I wanted to see how...
Ben Watt
Mar 22, 20216 min read
Â
Â
Â


Power BI: Smart Metric User Guide
Recently I built a dashboard for a client that sourced data from a large and varied number of data sources. It helped monitor a wide...
Ben Watt
Mar 16, 20212 min read
Â
Â
Â


Pie Charts: a pleasant slice.
In the Business Intelligence world, there is consensus among some that Pie Charts have no place on a report. There's even a Twitter...
Ben Watt
Jan 16, 20213 min read
Â
Â
Â


Our year in review. 2020.
As this unforgettable year comes to a close, I wanted to share a summary of the Datalineo journey over the last twelve months. It goes...
Ben Watt
Dec 21, 20203 min read
Â
Â
Â


Power Query: Cleaning data to keep only numbers
I had a requirement to clean out all data in a field except for the numbers. This was a plain text field where users would manually enter...
Ben Watt
Dec 16, 20203 min read
Â
Â
Â


Power Query: Sort + Distinct, a quick tip.
When you perform a Distinct operation in Power Query, the elimination policy is to keep the first instance it sees of the column(s) you...
Ben Watt
Dec 13, 20202 min read
Â
Â
Â


Browsing Tables & Columns in Microsoft Dynamics, using Power Query
I have several customers using Dynamics CRM and have built Power BI solutions using these as a data source. Dynamics CRM uses the Common...
Ben Watt
Nov 30, 20203 min read
Â
Â
Â


Power BI REST API with Python and Microsoft Authentication Library (MSAL)
Update Sep 2021. Great to see you here! I suggest after you read read this blog, don't miss the other two additions to the series, where...
Ben Watt
Nov 3, 20204 min read
Â
Â
Â


Power BI theme tip: Page Background
Using Power BI themes has allowed me to keep look and feel consistent. This is important to me as I put a lot of time and effort into...
Ben Watt
Jul 28, 20202 min read
Â
Â
Â


Analyzing your Microsoft Teams meeting attendees
Using the new Microsoft Teams feature to track attendees leaving & joining your meeting.
Ben Watt
May 26, 20204 min read
Â
Â
Â


Power BI meets Meetup.com
Ever found it hard to keep up with all of the Meetup.com events you are interested in? Same here. So as a Power BI person I thought I'd...
Ben Watt
Jan 14, 20204 min read
Â
Â
Â


Datalineo is Shortlisted for a Start-Up Award!
We have been shortlisted for the Start-Up Award as part of the 2019 Sandyford Business District Awards.
Ben Watt
Oct 16, 20191 min read
Â
Â
bottom of page