Lock up filter in Desktop file

[Marina]

Dear freinds, I need your help!

My question may by quite strange.

My company decided to implement only Power BI Desktop. We cannot use neither cloud version due to some security reasons nor Report Server version due to high price.

So we develop Data Model in Power BI Desktop and put a report level filter selecting certain Business Unit and send the pbix file to certain user assigned with this Business Unit. Each user should see only information on his Business Unit.

Such problem is solved in Power BI Service with row-level security when you assing account to the certaing filter.

But how can I solve it in Power BI Desktop I have no any idea. 

I cannot lock a filter in pbix file.

I cannot lock change of the pbix file .

Maybe I could make some manipulations in Data Model in Excel to prevent selecting Business Unit in pbix file?

Any ideas how to solve the problem? Please advice!

Thank you!

[v-caliao-msft · Accepted solution]

@Marina,

I have tested it on my local environment, this requirement cannot be done in Power BI desktop only. This feature is only for Power BI service.

By the way, the Power BI service is built on Azure. And uses Azure Active Directory (AAD) to store and manage user identities, and manages the storage of data and metadata using Azure BLOB and Azure SQL Database, respectively. You could get a better understanding of Power BI services security and then decide if you would use Power BI services or not.

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/

Regards,

Charlie Liao