Forum Discussion

amarsale85's avatar
amarsale85
Icon for Helper II rankHelper II
6 years ago

Effective username doesn't change

Hi Experts,   I am using SSAS tabular model to show/hide column for specific users. So i defined 2 Roles in this SSAS DB, Client 1 and Client 2. I added myself in role of Client 1 and added a colle...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago
Sounds like you are using import versus Direct Query, correct? If that is the case, the refresh will use the stored credentials in the data connection.
amarsale85's avatar
amarsale85
Icon for Helper II rankHelper II
6 years ago

By Direct query to mean "Connect Live" ? I don't remember what i selected because i thought it didn't matter. 

Should i create new report using "Connect Live" ?

 

Regards,

Amar