5 Steps, To Implement ABIS API
Download Power BI Desktop and Sign In into your Business Email
Connect to your SQL Server and Create a Report Sample
Install Gateway and sign in with same Power Bi Profile, in order to enable Power BI publishing to Web
Add Data Source and manage Gateway at this link
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
Register your Application on the below Link:
Verify Your custom domain, before granting access to your app on Azure Portal ( Not Shown in the demo Video)
Grant Access to Your Application into your Microsoft Azure Portal
Access the Design PMS Platform for Business Intelligence
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 A5W page, where the report will be loaded, in addition to an attached loading image.
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: