Tip #618: Mute power or powerless voice

Voice of the Customer breaks PowerBI

If you’ve been following our Voice of the Customer videos, you may have been tempted to install the solution and try it for yourself. For those of you using PowerBI to do some cool reporting on your CRM data, a timely word of warning from Jukka “Survivor” Niiranen: Currently there’s a known issue with the […]

Tip #447: To filter or not to filter – functional view

This seems to be the week of unsupported tips. I know, we said it before: Swim between the flags, and Use filtered views even if you use stored procedures. But what do you do if this particular report’s query is a monstrosity, adding custom indexes don’t help, and any attempt to restructure it just makes […]

Tip #358: How to delete deleted report

Import renamed report

No, it’s not a typo – I am going to talk about deleting the deleted. – “What?!” Let me explain. We all have that Rupert/Vernona/Joe/Jill on our team who think they know best and, for some inexplicable reason, management agreed and granted them privileges sufficient to deliver some real damage. Like going into SQL Server […]

Tip #347: How to use datetime fields in WHERE clause

Gotta love user Q&A sessions, like the one at Convergence 2015 that I had a privilege to take part in. Questions from users are always refreshing, very often challenging and sometimes they are just the reminder that any small bit of information that one possesses is not necessarily the common knowledge. On this occasion question […]