these are the report props, will show body props separately

thx jeff there is one lower level manager that understands it from an edi standpoint.   Generally speaking edi is more of an immediate gratification app where the hassle of xref...

kind of phil.   their decisions impact their oltp directly.  they dont really think about or understand the impact on a warehouse.

for example, say they have a customer hierarchy.   various bill...

• This reply was modified 6 months, 3 weeks ago by stan.

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, 3 weeks 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, 3 weeks 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 8 months, 1 week ago by stan.
• This reply was modified 8 months, 1 week ago by stan.