Forum Discussion

ptacquet's avatar
ptacquet
Frequent Visitor
8 years ago

Sharing Datasets

Hi,

 

I got a workspace wtih a dataset (with security roles configured) shared by an application.

This dataset is managed in a pbix file.

I got various reports based on this dataset.

It works fine.

 

I need  now to do a new report based on this dataset but only to other users.

With the application, i can't do this. 

 

Wath is the best option ?

  • Content packs: this feature seems to be deprecated
  • Publish the pbix file to a second new workspace. It doesn't seem the best option:
    • I need to configure the security, scheduling twice
    • Each evolution to the model must be published twice (a bit risky...)
  • A best idea ? I can't create a ssas cube.
Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago

    Hi there

     

    Could you not create a new PBIX connecting to the same dataset, and then modify the Security Permissions for the new users?

    • ptacquet's avatar
      ptacquet
      Frequent Visitor
      8 years ago

      Data comes from a dwh on premises.

      It's not a simple dataset, there's many tables, measures, roles.

      Security Permissions is identical, it's just the public that's different for a report.

       

       

      If i do a second pbix file with the same dataset, i'll have to maintain both models.. :-(

       

      Actually, i do pbix reports based on the data set published on the service.

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        Hi there

        I would suggest if possible to create a new PBIX where you connect to the Power BI Service Dataset?