It is nice to see so many posts that offering different solutions, as well as the performance analysis.

Regarding the real case scenario in my situation, I would expect to see...

Thank you Johnathan.

I only get this on my local settings. I don't have a sample package on the server. It is a development server. And it is the same server, but upgraded...

• This reply was modified 2 years, 2 months ago by  jay-125866.

Thanks Phil.

Appreciate your help!

Thanks Phil.  I'm going to update my packages to use the environment variables.

Still curious, what might caused this change since everything worked fine before.

Jay

Thanks Thom.  The users in my case are using their own credentials to run the report. I'll read more about Row-Level security.

Thanks!

Thanks for reply.  My dataset is basically a stored procedure that passing a Project ID as an input parameter. I'm going to read the article in your replay and may...

Checked production database this morning, and found total of 242 records. Only the first 141 rows showed the same last 4-digit value. After that, no more "same-value" issues.
Also  talked...