this article seems to talk about that "view".   i'll have to poke around looking for step/job completion status, limitations , latency etc while job is running etc.  i'm a bit...

thx Phil and Steve.

Phil I wouldnt want to do that to the community since i know how to use the stuff command and xml path.  I was being a bit...

didnt know.  so answer #2,  kind of piling on answer #1 is that the users who pivot would need minimally a pbi pro license.   i dont think we want to...

appreciate the support phil.   if anyone out there ends up in my shoes it sounds like the "Suite Scripts" team is the one you want for guidance.  I chose accounting...

• This reply was modified 1 year, 3 months ago by stan.

thx Brian and Phil.   If Netsuite's invoice etc API's can do this,  i would prefer to go that way.    I show a snippet below of their api list etc. ...

loaded question but i'll try.  for starters we plumb more than just pbi to cubes.  for example excel pivots.   i understand there is an extension to excel called power pivot...

not yet phil.   will look at it soon.

thx Perry and Phil.   Perry i'm not sure why you say vdi is better.  Phil, i dont see semantic models and ssas necessarily as alternatives.  i see them more as...

we are still having a problem down on the features where the singleton was originally interfering.   All features from all lines are showing up on all lines.  Below is an...

thx phil, i'm going to try to build on your structure to get those features.  I'll post results back here.

sure phil, this payload and query are representative.    we only get one set of features for each line number.

declare @xml xml=
'<root>
  <Header>
   ...

• This reply was modified 1 year, 4 months ago by stan. Reason: clarity

thx phil, i agree that pbi is super simple but the cost of ownership seems prohibitive.   Not to mention the lack of folder depth/organization in pbi.  by cost of ownership,...

i'm going to post a general question about using azure instead.   some hesitation but it seems like a way to address 2 challenges at the same time.   one of them...

thx chrissy i am assuming you are talking about this product and marking your post as an answer.    https://www.sqlbi.com/tools/tabular-editor/

probably log and email a ticket.  i (the bad cop) would start getting  the offenders to stop doing that slowly.