Power BI Copilot, AI Instructions And DAX Query Templates
Published on:
Learn moreRelated posts
Displaying The Output Of Detail Rows Expressions In Power BI Reports Using The Paginated Report Visual
In last week’s post I mentioned that while Power BI reports (unlike Excel PivotTables) do not support the Detail Rows Expression feature...
Using Detail Rows Expressions To Drill To A Different Fact Table In Power BI
If you have a DirectQuery fact table in Power BI you can use user-defined aggregations to improve query performance; querying a smaller, summa...
Analysing Power BI Data Using Copilot In Excel
This week there was another big Copilot-related announcement for Power BI – but on the Excel blog. You can now analyse data from Power B...
Power BI, M365 Copilot And The Importance Of DAX UDFs
This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
Understanding The “Database Was Evicted To Balance The CPU Load” Error In Power BI
A few months ago I wrote about a rare error – the “Maximum allowable memory allocation” error – that may occur when th...
Power BI DirectQuery Mode: A Better Choice Than You Might Think
For as long as I’ve been using Power BI – which has been from the beginning – the advice about which storage mode to choose ...
New Book: “Extreme DAX” 2nd Edition
“Extreme DAX” by Michiel Rozema, Madzy Stikkelorum and Henk Vlootman Continuing my series of not-reviews of the latest Power BI-re...
Improve Performance Of Staging In Fabric Dataflows Gen2 By Disabling V-Order
Quite a few new Dataflows Gen2 features were released recently without much fanfare, but that doesn’t mean they aren’t important. ...