All Posts

Hickey's Pharmacy had a vast amount of dispensary data available but had yet to unlock the useful information contained within. Read the Datalineo case study on how we unlocked this data.

In this quick video chat, Ben Watt, Datalineo CEO, shares some of his favourite moments from Data Céilí 2026.

Workhuman's cloud-based applications are helping some of the world’s leading global brands. connect culture to shared purpose.

Karla Sousa recently finished the Datalineo Level Up programme. This is an intensive 6 module programme created by Datalineo to help people move up in their Data Analytics career. It covers technical and personal skills and is fully hands-on. The Datalineo team was delighted to welcome Karla to our office to meet everyone. Karla got a walkthrough of the work we do and life at Datalineo, an obligatory coffee from our favourite local spot and muffins and brownies from our own A

XLVets is Ireland's network of 225+ independent veterinary surgeons. Each surgery was experiencing similar field issues, but working in isolation. Read the Datalineo case study.

Tips to help you when building a technology conference session.

Press Release: Datalineo opens a new office in the seaside town of Cascais, Lisbon, Portugal.

This post demonstrates how to use the TMDL view in Power BI,to generate multiple DAX measures simultaneously, intended for use in conditional formatting and to improve visual design.

Introduction In this blog post I will share how to effectively leverage conditional formatting with a low code approach suitable for enterprise grade solutions. I have found that there are two key components that are critical for success: Field Values – predefined measures that dynamically specify colour values, icons and even Unicode characters. Power BI dataflows – a low code method that creates a single source of truth of field values and is effortless to manage and ensur

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 three types of links in the navigation pane on the left. To set the record straight, I love the functionality of publishing a workspace as an App. Coupled with the not-so-recent addition of Audiences, they are now an excellent way for consumers to interact with a "solution" as opposed to a folder of reports/semantic models/dataflows/etc. When

In this blog post I will share with you how to effectively leverage the Dataflow Gen2 Fast Copy capability when ingesting large volumes of data. I have found that there are two key components that are critical for success: Enable high scale compute – allows use of Fast Copy connectors that benefit from the scalable backend of the pipeline Copy Activity. Meet prerequisite criteria – Fast Copy is only supported for a limited number of Dataflow Gen2 connectors and a limited numb

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 delayed. Looking at the full page of departures for today, I notice many departed late. I also noticed they got later as the day progressed. It raises that question oft noted that every delay has a further knock-in effect for subsequent flights in the day. Let's test that hypothesis! I loaded the departure data directly from the Pisa departures

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 to my inbox at 6am every day. Afterwards, I made some enhancements to the layout and thought I would share this with you. At high-level, the Flow is very simple: Get the weather and send the details to my inbox. Under the bonnet I had to draw on some relatively complex expressions to ensure the output was exactly as I needed. I will go into

This blog post demonstrates how to effectively use incremental refresh with binary files to drastically improve the refresh performance of your Power BI datasets and dataflows. Incremental refresh is widely understood and employed for structured, relational data sources like SQL Database and Azure Synapse. It is not as commonly known that incremental refresh can also be harnessed for other data sources such as binary files. The key to success is to ensure the binary files are

I use Power Automate to trigger Power BI dataset refreshes when files arrive in a source folder (like SharePoint Document library or Azure Data Lake Storage). In one scenario I had a dataset loading/combining files from multiple folders into separate tables. The files would land in the various folders at certain times of the day, often at once and in multiples. The issue I was facing was the Power Automate Flow would be triggered multiple times so I'd get failures that the da

In this blog post I will share how to effectively leverage the performance boosting functionalities available in dataflows when preparing large volumes of data. I have found there are two key components that are critical for developing efficient dataflows: Enhanced Compute Engine – loads data into a temporary SQL cache and enables Power Query to leverage query folding. Incremental refresh – partitions your data into smaller chunks to refresh only what you need. Focusing on th

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 with you a Python script to get the latest file and load it into a pandas DataFrame. This came from a recent Twitter conversation Ruth Pozuelo, who has been doing some very cool updates on the matplotlib Python module. She asked: Is it possible to access a dataset curated with Power Query or/and DAX outside Microsoft walls? Like a dataflow or

At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and business-impactful insight to the users. I'd like to share this with you! This is based on Power BI, so I'll talk about DAX and Power BI report design, but it could be adapted to any tool. Using the Adventure Works sample database I created a couple of examples. It reads like a DevOps User Story, which is good as it switches to being busines-driven over dat

Recently a customer provided access to an Azure SQL Database on their tenant. They had it secured using firewall rules and so requested any IP addresses from me to add to the rules. Given this was part of a Power BI Solution, this forced the need for an Azure Virtual Machine with a fixed IP and the Power BI on-premises gateway That immediately means cost in running the VM and time/effort securing/patching/updating the OS and the Gateway software. They lost me at hello! The Vi

Datalineo started operating in August 2018. Based on our calculator, that makes us four years old this August! We have thoroughly enjoyed the last four years and are delighted to see our team continue to expand and deliver best-in-class solutions across Logistics, HR, Manufacturing, Cybersecurity & much more. To celebrate this milestone, we are putting on our Power BI Kickstarter Class for free! This is a full-day, in-person class where you'll gain knowledge about building a