Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DataSet: Enable download/read disable upload/write/edit/publish

Is it possible to enble pbix file download, but disbale it's upload/edit in workspace?
Or, the same by other words - enable read and dsiable write permissions.

By download I mean NOT live connection - Measure definitions and Data View tab should be availbale

UseCase:

  1. A lot of users should have ability to play with local copy of dataset (*.pbix fille) and be able to modify and adjust it.
  2. But they should not have ability to replace/modify existing report in workspace

 

P.S. There are a lot of docs related to this topic, but still no short and clear answer
Short summary:

  1. Viewer Role: 
    +Protect from unwanted modifications (not able to publish)
    - Measure Definitions and Data View  NOT available -DataSet is available as a LiveConnection or DirecQuery import, but NOT available for download.
  2. Contributor role:
    - Do NOT Protect from unwanted modifications - Contributor can publish and replace existing dataset
    + Measure Definitions and Data View  available - dataset file is available for download
  3. Common advice - separate dataset and report files.
    Good advice, but I don't see how it could help to solve the problem

 

Need Help

3 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 

    Best way is to create a new WS where you let people play with the Dataset as they wish. End user or viewers should not consume reports in WS but in Apps. Here is an image on how to manage Workspaces

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Initially, I was thinking in the same direction - use deployment pipelines for this purpose...
      But with a bit invert logic (as far as you cannot deploy backwards from  PRD -> TST ->DEV)...
      Use TST as your untocuhable production, and time to time deploy new releases to PRD, where every workspace user has contributor role.

      However, I do NOT use this aproach - because it requires PPU license for each workspace user.

      Workaround that I currently use:

      1. Run powershell script that backups my workspace
      2. Share access to Backup folder to groups that are interested in dataset .pbix file.

       

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        3 years ago

        Sorry but I wasn't referring to PPU or Premium capacity nor was I talking about deployment pipelines.

        I think you need to better understand the Screenshot above.