All Posts

If you are planning to do a session at a technolgy conference or user group, then I'd like to help you write the title and session abstract in a way that attracts selection from the event co-ordinators and attendance from conferences delegates. I've enlisted some thoughts from a few close friends & seasoned speakers too, thanks to Alex, Andrew and Bob. Your session title Conference delegates will read your session title and likely choose from there. What should you put? The

Press Release. 18 November 2025, Dublin, Ireland Datalineo, a data analytics company that helps Irish companies make sense of their business data, has opened a new office in the seaside town of Cascais, Lisbon, Portugal. The first Portuguese-based employee started earlier this month. Datalineo plans to expand the office to a team of five in the next 6-12 months. “I’m thrilled to open our new office in Lisbon – our first outside Ireland,” said Ben Watt, CEO, Datalineo. “Portug

Introduction In this blog, I will demonstrate how to use the TMDL view in Power BI, to generate multiple DAX measures simultaneously,...

Introduction In this blog post I will share with you how to effectively leverage conditional formatting with a low code approach...

I recently had a minor whinge that when publishing a Power BI workspace as an App, it was difficult to tell the difference between the...

In this blog post I will share with you how to effectively leverage the Dataflow Gen2 Fast Copy capability when ingesting large volumes...

As I sit here in Pisa Airport after a wonderful break away with the family, I look in despair as my departure time gets more and more...

Recently I spoke at an event where we did a hands-on exercise to create a simple Power Automate Flow, which sends a daily weather summary...

This blog post demonstrates how to effectively use incremental refresh with binary files to drastically improve the refresh performance...

I use Power Automate to trigger Power BI dataset refreshes when files arrive in a source folder (like SharePoint Document library or...

In this blog post I will share with you how to effectively leverage the performance boosting functionalities available in dataflows when...

If you are making use of the feature to store your Power BI dataflow results in your own Azure Data Lake Gen 2, then I'd like to share...

At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and...

Recently a customer provided access to an Azure SQL Database on their tenant. They had it secured using firewall rules and so requested...

Datalineo started operating in August 2018. Based on our calculator, that makes us four years old this August! We have thoroughly enjoyed...

When analysing business processes which have a start time & end time it's not uncommon for KPIs to require the business duration between...

At a customer site, I developed some Power BI dataflows and datasets that connect to Azure Storage. Recently, we decided to secure the...

I've blogged twice (here and here) about authentication using the msal Python module. I'm going to cap off this topic with a third and...

This week the Power BI team announced an awesome new feature. It's the ability to run DAX queries against your Power BI datasets via a...

Back in November 2020 I blogged about using the Python MSAL library to authenticate to Power BI and call the REST APIs. In that blog I...