Overview
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.
Pre-requisites: A Microsoft PowerBI subscription or trial
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)
Key Features & Functionality
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
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.
Hi,
Just wanted to follow up on this. To provide more information, please refer to the attached screeen shot that indicates exception when calling GetAllReports. This is preventing us from using key functionality in PowerBI that we are relying on extensively. This integration should fail gracefully and return a code instead of exception. Please assist asap.
Since this latest release, I am seeing the following error when viewing my PowerBI Integration for the GetAllGroups function. Can someone please assist?
Error Evaluating UI Expression
Expression evaluation error [evaluation ID = 74999:462ac] in rule 'cat_int_powerbi_authcode_getallgroups' (called by rule 'cat_int_powerbi_authcode_reports') : com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.lang.NullPointerException: null
We are on AWS On Premise and this connected system is timing out while testing the connection. I tried from Appian Cloud and it works fine. Can you please confirm what setting to be enabled to make it connect successfully from an AWS On Premise server?
We tried using http proxy and the integration works to power bi but the connected system is still timing out.
Kindly assist.
Thanks.
Hitesh