You could try to partition the import and load the cache in parallel, but I have never done that and don't know if that will really eliminate the problem.

To be...

You can use AD Groups in Analysis Services roles to limit data, but row-level-security is to limit data from the end user and not entire entities (tables) or attributes. There...

You can use the following API to refresh a dataset: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup 

Here's a C# example on the .Net object model you can use to call the API: https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-complete-code

I'd recommend using Powershell, as it is much more robust than trying to do it in native SSIS tasks.

I like to use XMLA directly in the SQL Agent jobs. At least in my experience, the built-in SSAS processing task is a little clunky sometimes.

No worries. The dimension that was failing was most likely causing your other dimensions down the list not to process, and SSIS wasn't throwing the error like it should have....

In the world of multidimensional cubes, the value it's complaining about is usually the culprit (or part of it). I would do the following:

• Fully process the dimension in question

...

If the cube is processed "full", then all associated measure groups in the cube will also be processed. You may have to dive into the error a little more. For...

Processing all the dimensions first and then the cubes should work. If it doesn't, it might be because you're not doing a "full" process on the dimensions or you may...

In my experience it is usually locking/waiting of some kind (if you're referencing an external file, server or system), or a delay with the BIML add-in in VS/SSDT. You could...

It's important to understand your use-case better, before making decisions on a best way forward. Could you provide more details about that?

I don't necessarily pre-stage (with two separate staging areas), but I do prefer to do no (or minimal) transformations when I bring data into the staging area. All my transformations...

Scheduled I'm not sure about, but you can use the SSAS flight recorder to collect query execution info either to a table or log file. Look at the instance properties...

Aggregations will help with performance and is definitely something worth looking at. You're right, proactive caching isn't really what you want to do here...you just want to warm the cache...

yes, true 🙂