following the above... if you hide the error message then your code is fine and you are good to go (for a beer)

are you using any specific connector for D365 or are you doing straight SQL inserts/updates? if SQL then instead of trying to process that in SSIS load both headers and...

yes. do it as a SQL Server Agent Job - powershell script and load results to a table on SQL.

hum... I would not do it - use the correct UI https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16  as it does a bit more behind the scene - and while you are at it change...

yes - you need to create a login from credential (not login from windows) and then add that login to the required dbs as needed

it would be better you show us the code you are using for this as well as details of server/version

and what was the fix? its good to post the solution in case any other users face the same issue.

Sharing a report does not require a PRO license only - only PUBLISHING a report to a server requires that licensing.

Assuming you are talking about using powerbi on cloud -...

No... its Sunday... special extended weekend 🙂

regarding the update to null - depending on the frequency of that table being updated you may be able to create another table with same structure (including indexes), insert all...

spam again - we really should block this thing

info is on MS licensing document itself - if that one is wrong ....

you buy the license for 2019 - and that license allows you to install 2016 as part of downgrade license terms.

see https://docs.microsoft.com/answers/storage/attachments/96089-sql-server-2019-licensing-guide.pdf - page 39

so you to install sql 2016...

that ONLINE=ON is whats causing all that growth and elapsed time.

you should also add sort_in_tempdb = on.

and... the DDL you supplied does not include the filegroup it is being created...

and information about how you are running the index creation - within a transaction, multiple index being created or just one, online or off line, sort in temp db or...