Congratulations!  I don't feel I need to be marked as answering; you did all the hard work yourself.

If there is a lesson to be learned here, though, it is that...

Stan, I can't say, and I hate to sound like a broken record but one of the advantages of using an EXE and a command line interface is that you...

Stan, so glad you got it to work.  Regarding the fireAgain reference,  I think the AI script "learned" from something that didn't clearly indicate where it was getting that value,...

• This reply was modified 1 days, 2 hours ago by Lisa Slater Nicholls.

winscp's items need to be in GAC for that reference to be added.   been years but i'll try to go down that path.

This may be why (considering the environments I...

This is probably not what you want to hear but I've done a lot of FTP'ing from SSIS and I never had much luck with the FTP task.  Instead, I...

• This reply was modified 2 days, 1 hours ago by Lisa Slater Nicholls.
• This reply was modified 2 days, 1 hours ago by Lisa Slater Nicholls.

Hi - just a thought - now that SQL Server 2025 Standard Edition will allow for on-premises Power BI Report Server installation (see https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-consolidation-faq) , it seems like a good...

 I set up a separate , temp / workaround copy of the reports without a reference to the offending fields.

I guess I am not understanding why this is a "temporary"...

Hi again Stan, sorry I didn't help.  The only other thing I can think of -- and it may make no difference -- is to remove the two fields from...

• This reply was modified 8 months ago by Lisa Slater Nicholls.

Stan, you said the report is set not to cache, but the error indicates a shared dataset.  Have you checked the shared dataset's caching settings, not just the report?  (JIC)

I'd...

> Afaik there are only two possible values for the Category colum

AFAICS you are right -- but you'd expect there would be a 3rd value, equals8???

how it is executed

This might be key... is this query executed many more times than others you might be comparing it too?  If so, could the problem be an inability...

> And trying to teach a subject-matter expert how to 'do' IT is equivalent to teaching an actor how to dance.

MMM... usually, but not always.  I'd love to have a...

I have never used temporary sprocs, in fact I didn't know they existed <g>.

But to answer "when would they be useful", for you (Jeff) and danielk1, I thought there was...

Oops, Hang Liu, let me clarify something in turn:

ease of use refers to the data model’s usage from the report writer’s perspective, not necessarily the end user or self-service perspective....

Hi Hang Liu,

Everything you're saying makes sense to me.  Thank you.  I am 100% sure I would "graduate" from the FKs in the fact table to additional dimensional work if...