Power BI

Power BI lets you go from data to insights in minutes. Any data, any way, anywhere. And all in one view. But what about making sure that only the right people have access to the tools and data they are entitled to. For many larger organizations this is a big hustle – this is were Klywa can make a huge difference. Klywa is the row level access extension that allows you to share applications with a user restricted content. In Klywa you define the role and responsibility of the members of your team. Members with the same role share applications but with Klywa they only have access to the data that they are entitled to. User configuration is done once and the dataset is adjusted if a user role is changed. User administration is simplified, and it is easy to distribute the responsibility in your organisation. Try Power BI + Klywa to spread and maximise the utilisation of your analysis tools!

Implementation guide

Step one: Setup access keys

The first step is to setup your hierarchies according to your company organization in Klywa Access.

Step two: Download access keys

Now you are ready to download your access keys from Klywa Access.

PS C:\WINDOWS\system32> cd C:\KlywaAccess
PS C:\KlywaAccess> .\Install.ps1
Install Klywa Access Tools PowerShell Module
  • Download access keys by using the Get-TagetAccessFiles cmdlet
  • Run Windows PowerShell
    • Enter the command below (use your parameters)
PS C:\> Get-TargetAccessFiles -ApiUrl https://access1.azurewebsites.net/api/ -Username your_username -Password your_password -FilePath C:\Download -TargetId your_targetid
Download access keys

Step three: Update your data model

(Note: this requires Power BI Desktop, Jan 2019 or newer)

  • Download the Access Key Guide
  • Add a composite key in the fact-table according to the guide
  • Add the two downloaded access keys (CSV-files) to the data model and link the two access tables to the fact-table. In both cases with many-to-many cardinality
  • Locate “Modeling / Security / Manage Roles” in the ribbon
  • Create a Role “AccessRole”
  • Add a “[Username] = UserPrincipalName()” filter in the “UserToGroup”-table
  • Publish the report to the Power BI Service
  • Go to Security under DATASETS and add users, or better a Group with all users, to the “AccessRole”
  • Also, add users/group under “Manage Permissions”
  • If published as App – add the user/group one more time for access to the App