ABIS API

Alpha Business Intelligence Services

An API That Connect MS Power BI to Alpha Anywhere Platform

Download API

5 Steps, To Implement ABIS API

Step 1:

  • Download Power BI Desktop and Sign In into your Business Email

Link: https://powerbi.microsoft.com/en-us/desktop/

Connect to your SQL Server and Create a Report Sample

Step 2:

  • Install Gateway and sign in with same Power Bi Profile, in order to enable Power BI publishing to Web

Link: https://powerbi.microsoft.com/en-us/gateway/

  • Add Data Source and manage Gateway at this link

Link: https://app.powerbi.com/groups/me/gateways

  • Create Workspace into the your Power BI Web Portal

Publish your report from your Power BI desktop to this Specific Workspace

Get the URL link, Group ID and Report ID

Step 3:

  • Register your Application on the below Link:

Link: https://dev.powerbi.com/apps

  •  Verify Your custom domain, before granting access to your app on Azure Portal ( Not Shown in the demo Video)

Link: https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/add-custom-domain

  • Grant Access to Your Application into your Microsoft Azure Portal

Link: https://portal.azure.com

Step 4:

  • Access the Design PMS Platform for Business Intelligence

Link: https://www.designpms.com

Register your email and download a trial license for 14 days or Purchase a permanent license

Downloaded License file will include:

  • 3 Alpha Anywhere Grid

  • SQL query to run in order to create 3 SQL tables, that will store the power BI reporting  parameters

  • 1 JavaScript Function to embed into Project Properties in Alpha Anywhere Platform

  • 1 A5W page, where the report will be loaded, in addition to an attached loading image.

Step 5:

  • Implement the alpha grids and related SQL tables

  • Fill the required Grids fields by: Power BI username and Password, Client ID, Client Secret, Group ID, Report ID

  • Visualize the report, with an ability to apply filtering

Developer will be able to access the code of the delivered a5w page, where he can add user filters and session variables parameters as well, that can be given as parameters for the report loading method.

Implementation Video Demo

Microsoft Power BI offer Free credit to test and deploy Power BI Embedded Functionality.

When your free credit are consumed, Microsoft Power Will charge you additional cost in relation to the time of report rendering per user login. Refer to the below Link for more details:

https://azure.microsoft.com/en-us/pricing/details/power-bi-embedded/