Frederico mentioned the most important thing in his very first sentence, which is...

you don't need to measure everything - if someone asked you to do that they don't know...

Thank you, Jeff,  for your

very valuable comment. And I am doing that , too (top 10 worst , etc.).

but aside along from that, there is a specific question asked...

 SELECT STRING_AGG(d.value,',')
   FROM (
         SELECT value
          ...

1. If you measure it, you change it. (usually for the worse)
2. If you measure everything, you change everything (usually for the worse).
3. If you measure everything, you will see...

You're doing the wrong thing badly. You don't seem to know the table must have a primary key by definition; this is not an option! A row is not...

Here's one way to do this... it's horrible because, without a Clustered Index on the ID column, it takes 4 scans of the table and doesn't do much better with...

I believe it's because an empty string in Power BI is a value. Try using nulls instead and see if you get the intended behavior.

'' <> Blank() in Power...

Heh... sounds almost as bad as the default trace.  We blow through that in about 10 minutes.

On that note, I'll see if I have the time to add it.  I guess it's also time to have a "come to Jesus" meeting with them about their documentation...

Yep... agreed.  But you have to do something "special" for it to work.  I guess I don't see any real reason why SQL Server should be any different except that...

That's a really long time, David.  You should at least change your underwear every one or two weeks. 😀

The only reason why I got it right was because it has bitten so many people that work in every company that I've ever worked in including me back in...

Jeff,

Thank you for your input.  I'm glad I asked these questions.

With all the replies I am still unclear about which language type SELECT really falls under.  Just to be...

We haven't supported tables directly. I was surprised myself, and it's on a backlog, but I think it's relatively unimportant. Most of the time, having DDL/DML is better for...

If you really want help with such a thing, see the...