Blog

With a lot of people all over the world suddenly finding themselves working remotely, I thought I’d share some thoughts on what I think is one of the most challenging parts of a company going fully remote: maintaining relationships.

Explore how to configure model properties in Power BI for enhanced discoverability and improved data visualisation support.

C# 8.0 nullable references enable us to annotate our code with information that lets the compiler discover possible null-related bugs.

Whilst "read/write XMLA endpoint" might seem like a technical mouthful, its addition to Power BI is a significant milestone in the strategy of bringing Power BI and Analysis Services closer together. As well as closing the gap between IT-managed workloads and self-service BI, it presents a number of new opportunities for Power BI developers in terms of tooling, process and integrations. This post highlights some of the key advantages of this new capability and what they mean for the Power BI developer.

If, like me, you often find yourself unable to decide how to spend your time productively, it might be worth giving this post a read! Here Carmel runs through some of the things to consider when deciding which task to tackle next. These tasks can be anything from "send out finance report", to "call mum", to "decide where to go on holiday next year". We have a huge amount of options when deciding how to spend our time, so here are some strategies for whittling down that choice!

Improve the already-great Windows Terminal experience by following these tips for customizing the application to work best for you.

C# 8.0's nullable references feature dramatically changes a fundamental aspect of the language. In this post, Ian explains how to you can soften the impact by enabling gradually across your projects.

Azure Key Vault safeguards encryption keys & secrets for secure data access. It offers isolated storage, AD integration, RBAC, and access policies.

This is the final blog in a series about DAX and Power BI. This post focuses on the CALCULATE function, which is a unique function in DAX. The CALCULATE function has the ability to alter filter contexts, and therefore can be used to enable extremely powerful and complex processing. This post covers some of the most common scenarios for using CALCULATE, and some of the gotchas in the way in which these different features interact!

Ensure Power BI report quality by connecting to tabular models, executing scenario-based specs, and validating data, business rules, and security.

Explore data modelling in Power BI, including loading, shaping, and enhancing data. Learn key steps and practical examples.

I doubt that it's escaped anyone's notice that we have suddenly been thrown into a world which is pretty unrecognisable from that of even a few weeks ago. And I don't think any of us can claim to be managine it well all of the time, but in this post Carmel runs through some of the strategies and coping mechanisms which have helped her adjust.

Ian discusses inferred nullness and its significance in C# 8.0's new Nullable References feature.

This is the sixth blog in a series about DAX and Power BI. This post focuses on relationships and related tables. These relationships allow us to build up intricate and powerful models using a combination of sources and tables. The use of relationships in DAX powers many of the features around slicing and page filtering of reports.

Jess and Carmel recently gave a talk at Azure Oxford on Combatting illegal fishing with Machine Learning and Azure - for less than £10 / month. The recording of that talk is now available for viewing!The talk focuses on the recent work we completed with OceanMind. They run through how to construct a cloud-first architecture based on serverless and data analytics technologies and explore the important principles and challenges in designing this kind of solution. Finally, we see how the architecture we designed through this process not only provides all the benefits of the cloud (reliability, scalability, security), but because of the pay-as-you-go compute model, has a compute cost that we could barely believe!

Ensure reliable insights with endjin's automated quality gates for validating Power BI Dataflows in complex solutions.

We are currently living in extremely uncertain times. As we try to process these changes, many of us have found that we do not have the same mental capacity we once did. Some of that might be due to extra constraints on our time, but a lot of our brain-power is also spent trying to process the huge worldwide changes which are currently taking place. In this blog, Carmel talks about some techniques for managing that mental capacity, and how those apply in an ever-changing world.

C# 8.0 nullable references detect null-related errors and enhance code expressiveness.

This is the fifth blog in a series on DAX and Power BI. This post focuses on table functions. In DAX, table functions return a table which can then be used for future processing. This can be useful if, for example, you want to perform an operation over a filtered dataset. Table functions, like most functions in DAX, operate under the filter context in which they are applied.

Explore Azure Analysis Services for scalable analytics. Control costs via automation with Powershell & Azure DevOps in multi-environment setups.

Endjin's blog post details their project with OceanMind, using a serverless architecture and machine learning to detect illegal fishing.

Explore Behavior Driven Development using SpecFlow. Learn to create complex test data objects in Gherkin feature files with Corvus.NET project.

Explore C# 8.0's nullable references feature, as Ian discusses its impact on default nullability assumptions in this informative post.

This is the fourth blog in a series about DAX and Power BI. We have so far covered filter and row contexts, and the difference between calculated columns and measures. This post focuses on aggregators. We cover the limitations of the classic aggregators, and demonstrate the power of the iterative versions. We also highlight some of the less intuitive features around how these functions interact with both filter and row contexts.

Discover how to programmatically retrieve Power BI Dataflow refresh history for automated operations, enabling efficient dataset refresh management.