Share a pbix file with datasource credentials

[michael95677]

Is it possible to share a pbix file and have it keep the datasource credentials so a user can refresh the data? 

[vicenteajm21212]

please help i need to make an autoincrementing filter in power bi on a week basis

[lbendlin]

@vicenteajm21212 I think you wanted to open a new post.  Please try again.

[lbendlin · Accepted solution]

thankfully that is not possible. That would be a data security nightmare.

[michael95677]

Well, the idea being that there would be an account for our senior managers to use with read only access to only the tables we give those rights to. That would alleviate having to create Windows accounts for each user to have read access in SQL. At least I know the answer so thanks. 

[lbendlin]

Right, it's a conflict/dilemma between convenience and auditability.  You can't have both.