Here’s a quick blog about Connection String for BI Reports Data Source (Visual Studio). Connection string format Replace [xxx] and [y] to suit your organisation URL. Replace [zzz] with unique name of you organisation (Developer Resources). Don’t forget to enter the Credentials. Cheers, Sy
Getting the current user id using sql. Cheers, Sy
Great post on this matter.