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...

You're not providing enough information for anybody to help. What is the error message? What is the package doing?

There are numerous people in the SQL Server community (including myself) that either have blogs or training content, but you'll have to search their content to find everything you may...

There really isn't an "easier" way to deal with it...you have a many-to-many relationship because of the nature of the data, and you have to model it accordingly.

I'd recommend that...

I use stored procedures to implement the logic (or DML), but still use SSIS (or ADF) to perform the initial extract of the data into a staging area. I do...

Unfortunately not...your only choice is to go with their paid product or stay with the old version of Visual Studio.

Hypothetically speaking, Jeff 🙂

The premise of a Data Warehouse is to store historical information, so that you can go back in time and see what the value of a metric and/or KPI was...