Workarounds for “Canceled Due to Memory Pressure”
You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.
Category: Power BI
Datamarket: Quick Followup
“There are people out there whose jobs force them to be the place where two sources of data meet, and they are the ones who integrate and cross-reference that data […]
DataMarket Revisited: The Truth is Out There
Yeah, I love quoting movies. And tv shows. And song lyrics. But it’s not the quoting that I enjoy – it’s the connection.
Poll Results
Even though it is still open, the one-question poll results have stabilized. In fact, the percentages were pretty stable even from the beginning.
The 3rd Most Common Button in Data Apps is…
A little bit of food for thought today, delivered in a pictorial/humorous style but with a serious point. A Running Joke That Never Gets Old I’m quite fond of the […]
Auto-Modify Every Pivot in a Workbook
It’s been awhile since I’ve talked about Macros (also known as VBA). I think it’s overdue. Macros are nothing short of amazing. We couldn’t live without them at Pivotstream
DAX – Subtotals and Grand Totals That Add Up “Correctly”
Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.
DAX – Correlating “Fuzzy Time” Events in One Table with Precise Measurements in Another Table
The Streak is Broken… and a new streak begins. Well it was a full six-month run of posting every Tuesday and Thursday, Cal Ripken-like consistency. Then last week it ended.
My Experiences with Hosted PowerPivot, Part One
Almost exactly six months ago, after being a long time reader of this blog, I emailed Rob and asked him a question regarding something that I just couldn’t get my head around in DAX – Banding!
Converting from Peaks to Frequencies Using DAX
Folks I just can’t resist a quick followup on the Rat Sniffing Project. I… just… can’t. Plus I am absolutely worn down and don’t have the energy tonight for anything that isn’t inherently entertaining.
Peak Detection: A Surprising Usage of DAX
In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.
More Live PowerPivot Web Apps!
I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the entire thing here ahead of time.