Microsoft PowerBI (Password Grant)

Overview

Leverage PowerBI in Appian! Create and easily embed coherent, visually immersive, and interactive insights and enterprise-grade, real-time analytics. The two PowerBI plug-ins on the AppMarket deliver both 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.

This version of the PowerBI Connected System uses OAuth 2.0 Password Grant to authenticate users. Microsoft permissions are not honored in this case. So once authenticated with a specific user role (admin for example), then all embedded reports inherit that user's permissions.

Note: These plug-ins are deployed separately. You can use the Connected System plug-in by itself, but if you want to use the Component plug-in, the Connected System must be deployed and configured.

Pre-requisites: A Microsoft PowerBI subscription or trial

Key Features & Functionality

  • Export Report: Export powerbi Report
  • Get Export Status: Gets the status of the exported report
  • Download Report: Downloads the report file as an Appian document into an Appian folder
  • GetAllGroups: Returns all PowerBI user groups the current user is a part of in their PowerBI organization
  • GetDatasets: Returns all datasets
  • GetAllTilesFromDashboard: Returns all tiles in a Dashboard
  • GetReports: Returns all reports
  • GetDashboards: Returns all dashboards

Note: This Connected System will not work with the Microsoft PowerBI Component Plugin 1.1.1 or 1.1.2. Upgrade Component Plugin to 1.1.3

Anonymous
Parents
  • Hello, 

    I recieved the following error

    Interface Definition: Expression evaluation error in rule 'powerbi_getallgroups': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. com.fasterxml.jackson.databind.exc.MismatchedInputException: No content to map due to end-of-input at [Source: (String)""; line: 1, column: 0]

    How can I contact the developer? Any idea on how to solve this?

    Thanks.

Comment
  • Hello, 

    I recieved the following error

    Interface Definition: Expression evaluation error in rule 'powerbi_getallgroups': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. com.fasterxml.jackson.databind.exc.MismatchedInputException: No content to map due to end-of-input at [Source: (String)""; line: 1, column: 0]

    How can I contact the developer? Any idea on how to solve this?

    Thanks.

Children
No Data