thx jkunkel.   to be clear, i believe adf is a subset of fabric and that is probably what you intended to convey.

either way let me ask a question that nobody...

• This reply was modified 4 months, 1 week ago by stan.

thx jkunkel, do you mean adf?   the concern there is that its a big data tool.   if you want ssis you call it from there but why bother.  and im...

Thx Jeff.  You must be supporting a lot of code. I’m picturing bulk insert from a traffic cop sp on our server where I believe enough drivers and linked servers...

• This reply was modified 4 months, 1 week ago by stan.
• This reply was modified 4 months, 1 week ago by stan.

thx phil, can they go deeper than 1 level?  i mean the folders.

thx phil.  sorry for the late response.

thx eirikur.   this is a query we use for extracting and loading.    so specifying not null on a "table column" wouldn't really apply even on their side.   they cant...

thx philcart.   i may resort to that.  from what i remember the log is 99% accurate, sometimes just simply missing data.   i may have to pepper something somewhere not coupled...

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

hi phil, sorry for the delay.   no we purposely want it to go to the next step so as many erps can load as possible  before human beings step in. ...

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

thx jo, that is good to know and from what ive seen , the most plausible explanation so far.   i dont know that i'll spend the money to know for...

thx lisa, yep that was the first thing i did.  I set up a separate , temp / workaround copy of the reports without a reference to the offending fields. ...

i just remembered phil, if i remember correctly, the concept of directories isnt available under workspaces.   at least not with pro licenses and maybe no deeper than one level with...

thx steve.

good question phil.    i think my company is averse to putting them up there right now because of 1) the variety of erp's sourcing those reports , 2) the...

thx steve, it appears this post went off track with power query discussions.

anyway something occurred to me the other day.   i forget what its called but there is /was a...

thx Lisa, sorry for the delay, i just got back.

i got the same error embedding the query , ie not using a shared dataset.

the whole thing is pretty complex especially...