Forum Discussion

mbmferguson's avatar
mbmferguson
Frequent Visitor
3 years ago

Restrict ability to publish a Data Source set to import

I discovered that our analysis services AD permissions / restrictions are not maintained when importing the data but they are when using a Connect live connection to a SQL Server Analysis Services databse. I'm wondering if there's a way to limit certain users to only be able to publish using a live connection and restrict them from publishing with an import connection. I'm trying to avoid users importing data, then sahring the imported data with no restrictions applied.

Need Help

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    3 years ago

    Hi, I don't think that's possible. It's more an adoption you should teach to users. Explain the importance. Then you can just monitor. You could use the Power Bi Rest API for getting all datasets for workspaces checking the connection type. Look for the ones with import or something like that

    https://api.powerbi.com/v1.0/myorg/admin/groups?$expand=datasets&$top=100&$filter=datasets/any(u: u/contentProviderType eq 'PbixInImportMode'

    You could build some alerts to warn you if there is a new report with import to check if the source is the AAS.

    I hope that helps,