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/