Forum Discussion

michael95677's avatar
michael95677
Icon for Helper III rankHelper III
4 years ago
Solved

Share a pbix file with datasource credentials

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

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

5 Replies

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

    • michael95677's avatar
      michael95677
      Icon for Helper III rankHelper III

      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's avatar
        lbendlin
        Icon for Super User rankSuper User

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

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