GoatShipMate
@goatshipmate.bsky.social
Data Analyst mainly posting work-arounds for #PowerBI #PowerQuery #Excel etc, but also posting about #DataVisualisation in general.
#ThirdSector #Charity #DataViz.
I'm an #ActualPerson – my pseudonym is due to my job's social media policy
#ThirdSector #Charity #DataViz.
I'm an #ActualPerson – my pseudonym is due to my job's social media policy
Has anyone come across/solved this issue?
I'm trying to paste a table copied from Power BI Table View (aka Data View) into Excel. It has worked many times a day for months and months, but suddenly I'm getting this error.
"This file cannot be opened because of errors. Errors are listed in: ...log."
I'm trying to paste a table copied from Power BI Table View (aka Data View) into Excel. It has worked many times a day for months and months, but suddenly I'm getting this error.
"This file cannot be opened because of errors. Errors are listed in: ...log."
November 12, 2025 at 9:41 AM
Has anyone come across/solved this issue?
I'm trying to paste a table copied from Power BI Table View (aka Data View) into Excel. It has worked many times a day for months and months, but suddenly I'm getting this error.
"This file cannot be opened because of errors. Errors are listed in: ...log."
I'm trying to paste a table copied from Power BI Table View (aka Data View) into Excel. It has worked many times a day for months and months, but suddenly I'm getting this error.
"This file cannot be opened because of errors. Errors are listed in: ...log."
Is there a more annoying #Excel error message than this one?
"Yes I'm writing a 4-term LET() formula, I know what the equals sign at the start means"
"Yes I'm writing a 4-term LET() formula, I know what the equals sign at the start means"
November 5, 2025 at 2:18 PM
Is there a more annoying #Excel error message than this one?
"Yes I'm writing a 4-term LET() formula, I know what the equals sign at the start means"
"Yes I'm writing a 4-term LET() formula, I know what the equals sign at the start means"
New #Excel formula for me:
TAKE()
Allows you to choose a specific entry from an array.
For example
=TAKE({1,2,3,4},,-1) gives you 4
Syntax is:
TAKE(Array,row,column)
where -1 is the last
TAKE()
Allows you to choose a specific entry from an array.
For example
=TAKE({1,2,3,4},,-1) gives you 4
Syntax is:
TAKE(Array,row,column)
where -1 is the last
October 20, 2025 at 8:34 AM
New #Excel formula for me:
TAKE()
Allows you to choose a specific entry from an array.
For example
=TAKE({1,2,3,4},,-1) gives you 4
Syntax is:
TAKE(Array,row,column)
where -1 is the last
TAKE()
Allows you to choose a specific entry from an array.
For example
=TAKE({1,2,3,4},,-1) gives you 4
Syntax is:
TAKE(Array,row,column)
where -1 is the last
I'd be happier with Microsoft's ploughing so much into Co-pilot if at least some of that resource could go into making its error messages intelligible.
October 6, 2025 at 10:04 AM
I'd be happier with Microsoft's ploughing so much into Co-pilot if at least some of that resource could go into making its error messages intelligible.
It would be great to be able to change the width of columns in Table View/Data View in #PowerBI by right clicking & inputting a value (like you can in Excel). I have one that always auto-sets & its over a screen wide. Takes several drags to get it to a useable size. Any hope @itsnotaboutthecell.com
September 8, 2025 at 3:35 PM
It would be great to be able to change the width of columns in Table View/Data View in #PowerBI by right clicking & inputting a value (like you can in Excel). I have one that always auto-sets & its over a screen wide. Takes several drags to get it to a useable size. Any hope @itsnotaboutthecell.com
1001 Films to See Before You Experience a Minor Illness
Slightly diminish a book
Berrys of Wrath
Berrys of Wrath
Slightly diminish a book
1983
1983
September 8, 2025 at 3:25 PM
1001 Films to See Before You Experience a Minor Illness
A reminder that even MS call it COpilot, not Pilot.
September 2, 2025 at 7:59 AM
A reminder that even MS call it COpilot, not Pilot.
Trying to work out diagnose query tools in #PowerBI including using @cwebbbi.bsky.social's blog posts. Mainly I want to know is which step takes the longest, so I can optimise it, but if I sum up the "Exclusive duration" fields for each step, the last takes the longest & the 1st is shortest ...1/2
August 25, 2025 at 9:49 AM
Trying to work out diagnose query tools in #PowerBI including using @cwebbbi.bsky.social's blog posts. Mainly I want to know is which step takes the longest, so I can optimise it, but if I sum up the "Exclusive duration" fields for each step, the last takes the longest & the 1st is shortest ...1/2
How has it taken me this long to discover
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
August 24, 2025 at 8:32 AM
How has it taken me this long to discover
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
Table.FilterWithDataTable()
in #PowerQuery's M code?
Does anyone know how this compares speed-wise with merging on an inner join or using List.PositionOf() and then filtering?
I figured out how to make a 'card' like this in #POwerBI using a HTML Content Lite visual powered by a measure like:
SideCard =
"Do we need this option?
" & [Measure] & ""
SideCard =
"Do we need this option?
" & [Measure] & ""
I have a similar (if less technical) list myself, but this one is a regular one. In cards, please just let me be able to put my category label to the left (or right) of my callout value. There are imperfect / complicated work arounds, but this feels like it should be an easy one.
August 18, 2025 at 1:14 PM
I figured out how to make a 'card' like this in #POwerBI using a HTML Content Lite visual powered by a measure like:
SideCard =
"Do we need this option?
" & [Measure] & ""
SideCard =
"Do we need this option?
" & [Measure] & ""
If in #PowerBI you can't get the intersection to match the total row colour try this measure in 'Cell Elements':
IntersectionColour =
IF(
NOT ISINSCOPE('Table'[RowField]) && NOT ISINSCOPE('Table'[ColumnField]),
"#FFD700", //(rgb color)
BLANK()
)
[Remember to choose 'Totals only']
IntersectionColour =
IF(
NOT ISINSCOPE('Table'[RowField]) && NOT ISINSCOPE('Table'[ColumnField]),
"#FFD700", //(rgb color)
BLANK()
)
[Remember to choose 'Totals only']
August 15, 2025 at 5:22 PM
If in #PowerBI you can't get the intersection to match the total row colour try this measure in 'Cell Elements':
IntersectionColour =
IF(
NOT ISINSCOPE('Table'[RowField]) && NOT ISINSCOPE('Table'[ColumnField]),
"#FFD700", //(rgb color)
BLANK()
)
[Remember to choose 'Totals only']
IntersectionColour =
IF(
NOT ISINSCOPE('Table'[RowField]) && NOT ISINSCOPE('Table'[ColumnField]),
"#FFD700", //(rgb color)
BLANK()
)
[Remember to choose 'Totals only']
#WaitWhat? when you dedupe in #PowerQuery, it doesn't do it in order? Why am, I just finding this out now? This has potentially cost me :(
July 28, 2025 at 1:54 PM
#WaitWhat? when you dedupe in #PowerQuery, it doesn't do it in order? Why am, I just finding this out now? This has potentially cost me :(
New blog post. How to solve it in #Excel when those pesky yellow triangles pop up telling you your imports matches no exports
#PowerQuery
charitydatageek.blogspot.com/2025/07/exce...
#PowerQuery
charitydatageek.blogspot.com/2025/07/exce...
July 24, 2025 at 3:46 PM
New blog post. How to solve it in #Excel when those pesky yellow triangles pop up telling you your imports matches no exports
#PowerQuery
charitydatageek.blogspot.com/2025/07/exce...
#PowerQuery
charitydatageek.blogspot.com/2025/07/exce...
In terms of the July #PowerBI update I think it's the one around pies/donuts that most interests me initially, though I do really need to put field parameters through their paces.
powerbi.microsoft.com/en-us/blog/p...
powerbi.microsoft.com/en-us/blog/p...
Power BI July 2025 Feature Summary
This month’s update marks a notable evolution for Power BI. With richer connections to Microsoft 365, smarter Copilot features, and the integration of reporting through PBIRS and SQL Server 2025, user...
powerbi.microsoft.com
July 18, 2025 at 8:30 AM
In terms of the July #PowerBI update I think it's the one around pies/donuts that most interests me initially, though I do really need to put field parameters through their paces.
powerbi.microsoft.com/en-us/blog/p...
powerbi.microsoft.com/en-us/blog/p...
Can you add a non-constant average line to a line chart in PowerBI?
Everyone said no (at least not without superimposing), but eventually I figured out a work-around.
Everyone said no (at least not without superimposing), but eventually I figured out a work-around.
July 17, 2025 at 3:17 PM
Can you add a non-constant average line to a line chart in PowerBI?
Everyone said no (at least not without superimposing), but eventually I figured out a work-around.
Everyone said no (at least not without superimposing), but eventually I figured out a work-around.
Nice to pass my #PowerBl Data Analyst Associate reassessment again.
Of the 4 I got wrong a couple contained terms I don't recall hearing even with going through all the MS Learn material (which I think is the point in some areas – I also got DAX questions right that aren't in the materials)
Of the 4 I got wrong a couple contained terms I don't recall hearing even with going through all the MS Learn material (which I think is the point in some areas – I also got DAX questions right that aren't in the materials)
July 17, 2025 at 8:43 AM
Nice to pass my #PowerBl Data Analyst Associate reassessment again.
Of the 4 I got wrong a couple contained terms I don't recall hearing even with going through all the MS Learn material (which I think is the point in some areas – I also got DAX questions right that aren't in the materials)
Of the 4 I got wrong a couple contained terms I don't recall hearing even with going through all the MS Learn material (which I think is the point in some areas – I also got DAX questions right that aren't in the materials)
I asked Co-pilot to rephrase MS Learn's bit on using parameters in visual calculations in a way that was suitable for someone with ADHD and this is how it started out
July 13, 2025 at 10:47 AM
I asked Co-pilot to rephrase MS Learn's bit on using parameters in visual calculations in a way that was suitable for someone with ADHD and this is how it started out
It's a baking hot day in the middle of a heat wave with the wife away and the kids all grown up, so naturally I'm sat inside on my work computer cramming so I can renew my #PowerBI certification.
July 12, 2025 at 2:04 PM
It's a baking hot day in the middle of a heat wave with the wife away and the kids all grown up, so naturally I'm sat inside on my work computer cramming so I can renew my #PowerBI certification.
Using #SVGs to give a hand shaded/sketched feel to bar charts in PowerPoint by generating flexible fill code in #Excel using #DynamicArrays and RANDBETWEEN(). Pretty pleased with this. Learnt a lot getting to this point.
July 10, 2025 at 5:13 PM
Using #SVGs to give a hand shaded/sketched feel to bar charts in PowerPoint by generating flexible fill code in #Excel using #DynamicArrays and RANDBETWEEN(). Pretty pleased with this. Learnt a lot getting to this point.
I'm trying to create a new funnel chart for PowerBI this time using SVG. I have the complicated Maths bit to do next. Not sure whether I'm looking forward to that or not.
July 10, 2025 at 8:41 AM
I'm trying to create a new funnel chart for PowerBI this time using SVG. I have the complicated Maths bit to do next. Not sure whether I'm looking forward to that or not.
If you see this, quote post with a robot that isn’t from Star Wars, Star Trek, Dr Who and Transformers
July 10, 2025 at 8:38 AM
If you see this, quote post with a robot that isn’t from Star Wars, Star Trek, Dr Who and Transformers
If you find #PowerBI's grid lacking then here's a simple way I came up with to build your own, easily adjustable grid (including numbering) using DAX & SVGs (& I only started using SVGs this week). Make it even easier with #AHK.
charitydatageek.blogspot.com/2025/06/a-su...
charitydatageek.blogspot.com/2025/06/a-su...
A super easy grid for Power BI using DAX & SVG
charitydatageek.blogspot.com
July 7, 2025 at 3:42 PM
If you find #PowerBI's grid lacking then here's a simple way I came up with to build your own, easily adjustable grid (including numbering) using DAX & SVGs (& I only started using SVGs this week). Make it even easier with #AHK.
charitydatageek.blogspot.com/2025/06/a-su...
charitydatageek.blogspot.com/2025/06/a-su...