Thanks, I thought that might be...

Hikmer (6/6/2016)

---

In this case I typically use the Azure data marketplace and wire up to the Date Data source (free) and have a really detailed date table. I just...

Adam Aspin (6/6/2016)

---

Hi Hikmer,

There are many ways of adding time intelligence to Power BI dashboards - this is only one among many - in fact I describe how to create...

Hikmer (6/6/2016)

---

Thanks for the detailed article, however I would like to ask how all this work saves any time for a BI Developer as opposed to simply adding a role...

No problem. I think DAX is absolutely amazing in terms of what you can do with it, but I absolutely love...

alex.snowdon-darling (6/6/2016)

---

Thanks for this great post. But, how can we add date ranges for business use?

Businesses would usually work on a Fiscal calendar, and need to know data within date...

Hi

It's not working because the WHERE clause becomes:

WHERE id IN ('45,72')

which obviously won't work as you have a varchar value there. One way you could get around it is to...

Glad you got it sorted out - sounds like you had fun 😀

There will be a good reason why the user saw the behaviour they did. SQL Server handles permissions...

WWDMark (8/8/2013)

---

Thanks Duncan, really appreciate your response and suggestions. I've been using SQL trace and profiler to capture various performance counters and have been monitoring the most expensive/long running...

Hi Mark

This article has some useful information on collations. In their recommendations at the end, it says:

If you are considering a SQL collation based only on the performance characteristics of...

It is likely to be something to do with the VIEW DEFINITION permission. If the users don't have it or have it explicitly denied on the schema then that could...

Just have a look in the properties of all the relevant tasks. The first three, all in the "Control Flow" tab, have the FailPackageOnFailure property which you can set in...

Good question (well I liked it anyway). Easy to understand what was being asked, and easy to work out what the answers were if you had the required knowledge. It...

Good question, thank you. Nice to see a question on locking, as it can be quite a fascinating topic 😀

Duncan

Thanks for the question. Good to have one on SSIS for a change.

Duncan