Editing Power BI (section)

===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.