Microsoft PowerBI (App Owns Data)

Avail PowerBI in Appian without user credentials. You can easily create and embed coherent, visually immersive, and interactive insights and enterprise-grade real-time analytics. This PowerBI plug-in on the AppMarket delivers a Connected System to easily access some of the most commonly used APIs, as well as Components to PowerBI’s embedded Dashboards, Tiles, Reports, Report Builder and QnA component.

Microsoft PowerBI App Owns Data(Client Credential) uses the Client ID, Power BI Subscription ID and a Client secret Authorization Code to authenticate the App. It passes the 'App Owns Data' access token for all embedded graphs.

The download package contains App Owns Data (Client Credential) version: Microsoft PowerBI App Owns Data(Client Credential) which uses the Client ID, Power BI Subscription ID and a Client secret Authorization Code to authenticate the App. It passes the 'App Owns Data' access token for all embedded graphs.

Note: You can use the Connected System plug-in by itself in any integration, but if you want to use the Component plug-in, the Connected System must be deployed and configured. (You will also need to set the parameter ‘isAppDataConnectedSystem’ to true in the component while accessing it with this Connected System)

The package also contains a video demo for how to use these components together in Appian. It requires that the Connected System App Owns Data(Client Credential) plug-in and Component plug-in are deployed already.

Functionality provided:

GetAllDatasets: Retrieves all Datasetsthe app has access to GetAllGroups: Retrieves all groups the app has access to GetAllTilesFromDashboard: Retrieves all tiles in a Dashboard GetAllReports: Retrieves all reports the app has access to GetAllDashboards: Retrieves all dashboards the current user or group has access to GetAllPagesInReport Retrieves all pages within a given report id GenerateReportExport Trigger generation of an export of a report to a file of desired type GetExportReportStatus Retrieve status of export generation job DownloadReportfromExport Download generated export and save as an Appian document

Pre-requisites: A Microsoft PowerBI subscription or trial

Added functionality to download CSV and XML reports from export.