Forum Discussion

Mattias Sjostedt's avatar
Mattias Sjostedt
Copper Contributor
Aug 24, 2018

How to make access to a Report created using data connection to Analysis services generic

Hi!
I have a challenge with my excel-report made with Analysis Service towards DB Cubes using Windows Authentication. As of now it is connected to my username/db-access (windows auth) but I would like to make it possible for "anyone" to run it every morning.

I suspect that it has something to do with the access the other user has when opening the report but as I understood it the report/connection would use my credentials? Shouldn't it be possible to open it if another user has the same access as me?

Does anyone now how make it generic so anyone can open it?

Thanks in advance!

No RepliesBe the first to reply