Editing Power BI

==Background==

Power BI is used as the main BI tool in K'aute Pasifika.

Currently only a limited amount of Pro licences are available, primarily for team leaders and SLT. This may change in future depending on uptake and utilisation.

==Key information==

The approach used is to make all content available as Apps, using mail-enabled security groups for access.

Given the limited number of users, a single group 'PBI Aiga' is currently used. Also because of the relatively small number of apps, any content not relevant for all users is defined on a per-user basis in the App configuration.<ref>A good example being the [[Admin]] app.</ref>

K'aute have Tenant Admin permissions, while Cloudland manage all licencing and group management.

Also note that a shared mailbox <code>data@kautepasifika.co.nz</code> is used to communicate to groups or provide updates where necessary.

==Configuration==

An 'on-premises' gateway is used to connect data sources to the Power BI service. This runs on <code>CL1KPAAPP02</code> (primarily to have direct access to [[Aiga]]).<syntaxhighlight>gateway name - "test"
gateway email - "data@kautepasifika.co.nz"
gateway password - "data@kautepasifika.co.nz email password"</syntaxhighlight>

===Gateway connections===

Current data sources and connection information is summarised in the following table:

{| class="wikitable sortable"
! Data source !! Type !! Connection info
|-
| Aiga || Local SQL Server || Set <code>CL1KPAAPP02\sqlexpress</code> as data source in app - gateway stores credentials to access this service
<code>Connection Name</code> - <code>kaute-aiga</code>
|-
| kpt-rds || Cloud db || Configured as system DSN (<code>kptpg</code>) and used in gateway connection string
DB user details;
<code>Connection Name</code> - <code>kptpg</code><syntaxhighlight>
username - pbi_reader
password - YuO*******Nl
</syntaxhighlight>
|-
| Kaute Postgres || Azure DB || Configured as cloud connection in PBI service
|-
| Sharepoint ||  || Configured as 'Web' connection using report author credentials<ref>Note this is really stupid and will need changing if user account is retired</ref><code>Connection Names</code> -<code>kaute-admin_reception</code>and  <code>kaute-admin_reception_2024</code>
|}

All Power BI app ownership is assigned to '''data@kautepasifika.co.nz.'''

Only this account has permission to manage the connections and the data gateway.

==References==