(While I'm at it, say I have a bunch of recurring business costs, like rent and gas and the like. I can sum those by quarter (say) and then...

• This reply was modified 1 year, 3 months ago by Martin Schoombee.

Like, one starter consists of something like 7 parts water, 4 parts flour, 3 parts potato starch by volume). And starter is listed as an ingredient... Do I create...

If I have some time, I plan to do something about that next year. Stay tuned!

This is a tricky modeling question, and one that is difficult to answer without a lot of context and spending some time considering all the options (and side-effects of those...

• This reply was modified 1 year, 3 months ago by Martin Schoombee.
• This reply was modified 1 year, 3 months ago by Martin Schoombee.
• This reply was modified 1 year, 3 months ago by Martin Schoombee.

Can you provide some more details around the error-handling in your PowerShell script? I have found in the past that the meaningful part of the error messages aren't always visible...

Analysis Services partitions have to be refreshed as a unit, meaning that you cannot selectively update certain rows of a partition. If your large cube only has one partition for...

I looked at the two blog posts you referenced, and I think it's pretty clear (especially from Jason's post) that these "slice" entries are purely metadata entries that are generally...

Could you share the source of this recommendation?

There might be various good reasons why access to a production data warehouse cannot be granted: It may be a heavily regulated environment, with PII or PHI. Or they might...

Download from here: https://www.microsoft.com/en-us/download/details.aspx?id=100619

Full reference here: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/power-query-source?view=sql-server-ver16

The purple boxes in the articles are your friend 🙂

Tabular Editor (I have the paid version) allows you to save the model as a BIM file, but I haven't tested it...at minimum I think you'll have to change some...

Can you share the link to Jeroen's explanation?

The Self-Hosted IR is...

I agree with both responses.

In my experience, once Microsoft stops investing in a product for a few versions it is most likely because they are working on something new. We...

Message Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4322.2 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 12:41:09 PM Package execution...