The Detail Rows Expression for the measure needs to include the USERELATIONSHIP() function as well, because the DAX formula for the drill-through is executed independently from the measure itself and...

This would be extremely laborious to do in SSIS, and I wouldn't recommend it. I would use either Power BI and its "Analyze in Excel" feature for something like this,...

I'm using it on a project to extract data from Dynamics CRM Online. I've been using the developer license to test in the past, and it works well but doesn't...

This article should point you in the right direction: https://www.sqlbi.com/articles/understanding-the-difference-between-lastdate-and-max-in-dax/

thanks martin i have seen this case happen many time on other projects with batch files but was unable to confirm this. now that i know someone else has...

Do you have appropriate logging and error handling within the PoSh scripts themselves? I have seen cases where scripts have apparently completed 'successfully' (ie, they reported success to the...

No worries..always fun to figure out what gets translated to what in the different tools.

I believe it's because an empty string in Power BI is a value. Try using nulls instead and see if you get the intended behavior.

'' <> Blank() in Power BI

I unfortunately don't know of a more elegant way, and have used empty script tasks in the past as a starting point.

You'll probably have to do something like this: https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1200/supplemental-lesson-implement-dynamic-security-by-using-row-filters?view=asallproducts-allversions

To an extent, yes. Some tools, as good as they are, require a lot of monotonous and repetitive work and we're new seeing tools in some of those cases that...

BIML is that free tool. Use BIML Express in Visual Studio.

BIML could be your friend in this case, to generate all of these packages and save your sanity.

Ok gotcha, so it's really only the lookup for existence that's an issue.

How about assigning surrogate keys in your destination table, and then building either filtered indexes or partitioning the...

From a partitioning point of view, just think of a way in which you can structure your source query to get a somewhat equal distribution. Dates work well for this,...