Milliman chooses Power BI Embedded for their Integrate application
[vc_row][vc_column][vc_column_text]
Milliman chooses Power BI Embedded for their Integrate application
Today, we’re excited to share how Milliman, a global market-leader in actuarial-products and services, has integrated Power BI Embedded into its solutions. Saptarshi Mukherjee, Senior Product Marketing Manager of Microsoft Power BI, met up with Paul Maher, Principal and Chief Technology Officer of the Life Technology Solutions Practice at Milliman, to welcome him and talk more about their solutions.
Saptarshi: Can you tell us more about Milliman and your market-leading cloud solution, Integrate™?
Paul: Milliman is among the world’s largest actuarial and consulting firms, with offices in major cities around the globe. The Life Technology Solutions practice provides products and services to the actuarial community. Powered by the Microsoft Azure Cloud, Integrate is the first solution to effectively tear down silos and replace old tools and protocols with a state-of-the-art platform that improves financial and risk management, maximizes operational efficiency, and enables strategic allocation of human capital. Insurance companies can now access unlimited computing resources with Microsoft Azure to perform compute-intensive, mission-critical work.
Saptarshi: How are you using Power BI Embedded in Integrate?
Paul: Power BI Embedded enables Integrate users to quickly create and share data through interactive dashboards and reports, all in the cloud. Power BI Embedded provides a rich immersive experience that allows Integrate users to visualize and analyze data in one place, simply and intuitively. Using Power BI Embedded, Integrate delivers a scalable and cost-effective solution that meets the ever-growing BI demands of users.
The ability to embed Power BI in Integrate was key to ensuring that the end-user experience was seamless for all dynamic BI requirements.
![pic1[2] pic1[2]](https://managedsolprod.wpengine.com/wp-content/uploads/2023/07/23cccfeb-53cc-4e74-90aa-392e9ea96c17.jpg)
![pic2[2] pic2[2]](https://managedsolprod.wpengine.com/wp-content/uploads/2023/07/e7dc9600-34f1-466e-aef4-7be67eeb0a06.png)
![pic3[2] pic3[2]](https://managedsolprod.wpengine.com/wp-content/uploads/2023/07/0aca15f9-8d11-43d3-bdee-cad3db941768.png)
Saptarshi: Why did you choose Power BI Embedded?
Paul: After extensive research on so-called “best of breed” offerings in the market today, it was clear that Power BI Embedded was the right choice for Integrate. In summary, some of the key capabilities that made Power BI Embedded so compelling are:
-
Cloud-scale analytics service that could be embedded in our solution
-
Ability to visualize and analyze data in one place, simply and intuitively
-
Unlimited data visualization possibilities through open-source custom data visualizations
-
Scalable and cost-effective, and able to meet ever-growing BI demands of our customers, in a pay-as-you-use pricing model
-
Power BI Embedded is a cloud service, which allows the user to constantly take advantage of new features and improvements as they are rolled out
Saptarshi: Data security is obviously very important in your industry and at your company. Can you tell us more about the security details implemented in Integrate?
Paul: All access to Integrate by our customers, end-users, and by our Milliman team, is governed through industry-standard security processes. These include customer-managed authentication through SAML 2.0+ and ADFS 2.0+ single sign-on, and role-based access control.
With the establishment of single sign-on, all authentication and role assignment responsibilities are given to our customers, allowing them full control over assigning and configuring access for their personnel. The role-based access control allows customers to craft custom roles based on their needs, using a robust set of granular permissions.
This ensures that each user is only allowed to perform the specific role they have been assigned, and controls what data they have access to. The app-token based authentication and row-level security in Power BI Embedded allowed us to continue using our existing security methods and make it transparent for the end-users.
Saptarshi: What are your customers saying?
Paul: The reaction has been extremely positive from our customers. The addition of dynamic BI in Integrate by leveraging Power BI Embedded and Azure Cloud Services gives users access to data, and the ability to interpret data in ways that have never before been possible! Being able to do all of this in a secure and cost-effective way was a key requirement. Other capabilities include:
-
The ability to secure data in a multi-tenant application using Power BI Embedded, with row-level security. Users can create one set of reports and datasets, and then use them with multiple users and customers. Each customer can view the same reports, but only see the data that they are allowed to see.
-
The simple billing model, which uses report sessions, has been well received by end users.
Integrate provides business insights and real-time information to help decision makers react quickly to known and unknown risks, and to help them make decisions to protect their company.
Saptarshi: Those are all great insights on Integrate and Power BI Embedded. Thank you, Paul, for taking the time to talk with us. It’s been great to hear how Milliman has been able to fully leverage Power BI Embedded. We look forward to staying in touch with the work you’re doing.
[/vc_column_text][/vc_column][/vc_row]
Introducing the new Power BI JavaScript API

Introducing the new Power BI JavaScript API
Today we are excited to announce the release of our new JavaScript API, which provides bidirectional communication between Power BI reports and your application. The JavaScript API enables you to more easily embed reports into your applications and to programmatically interact with those reports so that the applications and the reports are more integrated. Two of the key features to call out with today's release are: much more advanced filtering of reports, and control over page navigation.
With this new functionality your application can open reports with the correct context for your users, as well as change that context after the report has already been loaded. For example, you could open a report to a specific customer and change that customer automatically as the user interacts with other parts of your application.
How does embedding with Power BI work?
To best understand the benefits of the Power BI JavaScript API, let’s examine how embedding in Power BI currently works. Embedding a Power BI report in your application is done with an iframe, which is hosted as part of the app. The iframe acts as a boundary between your application and the Power BI report. With no way to pass infromation through the iframe, the report cannot interact with your application and your application can’t interact with the report. While the iframe can make the embedding process a lot easier, this lack of interaction between your application and the Power BI report can sometimes make it feel like the report is not really part of your application.

Now the new Power BI JavaScript API will allow you to write code that can securely pass through the iframe boundary, so that your application can programmatically perform an action in a report and listen for events from actions that users make from within the reports themselves.

What can you do with the Power BI JavaScript API?
With the JavaScript API you can manage reports, navigate to pages in a report, filter a report, and handle embedding events. The following diagram shows the structure of the API:

Manage Reports
The JavaScript API enables you to manage behavior at the report and page level:
-
Embed a specific Power BI Report securely in your application - try the embed demo application
-
Configure the report with the following settings:
-
Enter and exit full screen mode
Navigate to Pages in a Report
The JavaScript API enbales you to discover all pages in a report and to set the current page. Try the navigation demo application.
Filter a Report
The JavaScript API provides basic and advanced filtering capabilities for embedded reports and report pages. Try the filtering demo application, and review some introductory code here.
BASIC FILTERS
A basic filter is placed on a column or hierarchy level and contains a list of values to include or exclude.
const basicFilter: pbi.models.IBasicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "Store",
column: "Count"
},
operator: "In",
values: [1,2,3,4]
}
ADVANCED FILTERS
Advanced filters use the logical operator And or Or, and accept one or two conditions, each with their own operator and value. Supported conditions are:
const advancedFilter: pbi.models.IAdvancedFilter = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "Store",
column: "Name"
},
logicalOperator: "Or",
conditions: [
{
operator: "Contains",
value: "Wash"
},
{
operator: "Contains",
value: "Park"
}
]
}
Handling Events
In addition to sending information into the iframe, your application can also receive information on the following events coming from the iframe:
-
Embed
-
Reports
-
pageChanged
-
dataSelected (coming soon)
[vc_row][vc_column][vc_column_text]
3 Ways to Embed Power BI
Want to share your Power BI reports and dashboards as part of a website or application? This week, Guy in a Cube looks at three ways to embed Power BI, including publish to web, using the REST APIs, and the new Power BI Embedded service within Microsoft Azure.
[/vc_column_text][grve_video video_link="https://youtu.be/egP0GHSOUIM"][/vc_column][/vc_row]