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 3 months, 3 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 3 months, 3 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...

thx tav29, unfortunately im in report builder and i dont think there is such a "feature".

hi tav29.   no calcs in the report.   yes, i ran what you suggested.   also, i saw the underlying data so im reluctant to try other algebraic solutions.   my boss is...

i finally got this darn thing to run in chunks of dates.   right from openquery.    not ideal but since they have an index on date, i tried it and...

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