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
  • Hi Debesh, 

    Thank you for reaching out! Have you tried utilizing the "Report an Issue" feature? It is located on the right side of the listing under the Feedback header. This is the recommended option for reporting any possible bugs that may be present in the plug-in.

  • Hi - is anyone reading the issues stated below? Seems like no responses to any of the concerns raised with this plugin?

    Is there any other way to connect with the Vuram team that developed this plugin?

    Thanks

    Debesh

  • any update on this please?

  • Hi,

    Since this latest release, I am seeing the following error when viewing my PowerBI Integration. 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

  • Hi,

    Since this latest release, I am seeing the following error when viewing my PowerBI Integration. 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

  • v1.1.10 Release Notes
    • Upgraded Jackson libraries and added license file

  • v1.1.9 Release Notes
    • Upgraded Jackson databind and added license file

  • Hi

    I'm getting an integration error when I try to Download Report from Extract for a CSV file.:

    IntegrationError

      • title"Error Code 418"(Text)
          • message"Unsupported file type returned by PowerBI"(Text)
              • detail"{"document-error:":"Unsupported content type returned","returned-content-type:":"text/csv"}"(Text)

              The functions work ok for a PDF doc.

              I've also tried Generate Report Extract, Extract Status and Download Report from within MS-PowerBI TRY IT functions and it shows the transaction data from the report.

              No logs are generated for the Error Code 418.

              I've attached screenshots of the process that I followed

              Can you assist on this issue please?

              Thanks

              DebeshPowrBI Download Error for CSV.docx

            • v1.1.9 Release Notes
              • Enabled Token Refresh + Bug Fixes
            • v1.1.8 Release Notes
              • Security Updates