thx phil, i saw that today and wondered.

for the community i think i was being stupid.   vfactsales didnt have the handful of new columns in it.   i only noticed when...

thx morgan3445.  there is no edit dax button in the properties pane of my sales table.

thx phil, as always very useful info.

that seems to have done the trick.  ARGHH!

i may have found something,  hold the phone    https://stackoverflow.com/questions/18702987/olede-error-login-failed-for-user-domain-computername-28000

thx jeff and frederico.     if the odbc driver's vendor comes up with something i'll post it here.

the good news is that i showed my boss the potential breach and...

thx phil, yes we already use an azure vm machine 2022 as a dev box.   And have exercised everything but ssas on that box to this point.

a few words of caution to the community...

1. use this link as a guide, it has info you wont figure out yourself https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-to-connect-to-mysql-in-sql-server-management-studio/ .  I think that nested setting has...

thx phil, thats what i thought.   without data factory which i saw last time can "call" ssis, its not happening.   we dont pay for data factory.

i did once before on this very subject but its been a while.   and sometimes things change.   and sometimes the ms documentation is so geared to selling and filled with...

• This reply was modified 7 months ago by stan.

no we believe saas is simply the service (eg sql server) without the maintenance (eg throwing additional resources like space etc at it when necessary).

• This reply was modified 7 months ago by stan.

this seems to answer the question if that provider mentioned previously is the/a right path...  https://stackoverflow.com/questions/66213672/import-active-directory-to-sql-server   .

• This reply was modified 7 months, 2 weeks ago by stan.
• This reply was modified 7 months, 2 weeks ago by stan.

i see an approach here that leverages the script task but not being that good at .net dont see how it can be limited to a specific domain controller https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-task-examples/querying-the-active-directory-with-the-script-task?view=sql-server-ver16

i see an odbc driver at this site but still wonder if our existing sql drivers cant establish this kind of communication?  this looks like an open source product.

https://www.mysql.com/products/connector/

this article describes the crazy workaround where you attach a guid to each record on the 2nd thru nth params to make  them refresh.  https://bpmsbi.wordpress.com/2011/04/23/ssrs-cascading-parameters-refresh-solved/    .

as for stopping my...

• This reply was modified 8 months ago by stan.