Meet us at WordCamp Europe | ShopTalk | DrupalCon Conferences to explore our solutions. Know More
Get Your Free Trial Now
×Thank you for your response. We will get back to you soon!
Something went wrong. Please submit your query again!
Benefits
Embed Power BI Artifacts
Connect and embed Power BI Reports, Tiles or Dashboard and other Power BI artifacts in a DNN website.
Manage Power BI Content
Manage permissions for Active Directory (AD) users or security groups on various Power BI artifacts such as dashboards and reports.
Restrict or Filter Power BI Content
Based on the DNN roles, restrict the content of Power BI reports and filter the content of reports based on assigned roles in Power BI Desktop.
Use-Cases: Embed PowerBI Reports
1. Embed Power BI Reports for Customers
- An organization has a DNN website where they want to display the Microsoft PowerBI report to clients or employees from other organizations. The employees can be from multiple Azure AD / Office 365 tenants.
- In order to view the Power BI reports and content, the client or organisation must purchase a subscription or membership for their employees.
- Filter the report's content based on the user's membership. Users with free membership, for example, should not be able to access the report's premium content.
- Furthermore, users who register during the checkout process should have an account created in Azure AD so that they can use the same username and password to log in (Single Sign-On) to the DNN website.
User Flow
- After logging into the DNN website, the user can access or view the Power BI report based on the membership and security group assigned to the user.
- Non-logged-in users will need to log in to view report content.
- Assume there are three membership levels: free, pro, and premium. If the user has a pro membership, the filtered content of the embedded Power BI report should be visible. It will be based on the filters that the administrator has set on the pro roles using RLS (Row Level Security). If the user upgrades to premium membership, he or she should be able to see filtered content for both pro and premium roles.
- Users who do not have an active membership will be prompted to upgrade their membership in order to view the content.
2. Embed Power BI Reports for Organizations
- An organisation has a DNN website where they want to display Power BI artifacts (dashboards, datasets, reports, tiles, and so on) to employees.
- To view the reports and content, an organization's employees must have Power BI premium access.
- The content of the Power BI report embedded into DNN would be dynamically updated based on the current user's [Login with Azure AD / Power BI credentials] applied filters, bookmarks, and so on.
- The Power BI reports would also be accessible to employees performing the SSO with Azure AD credentials.
- Employees would be able to view reports from their Power BI dashboard on their DNN page. Based on the plugin configurations, DNN admin can assign employee specific permissions to respective reports.
User Flow
- Employees from an organization who have a per user PowerBI Premium/Pro license have been granted access to the Power BI shared workspace.
- Employees or users log in to their Power BI dashboard and customise the reports by using filters, bookmarks, and so on. The same user visits the DNN website and Single Sign-On (SSO) using their Azure AD/Power BI credentials. The personalised report content is accessible after successful SSO.
-
User 1 and User 2, for example, have access to the Power BI shared
workspace (eg: Covid-19 US stats).
User 1 (johndoe@onmicrosoft.com) logs in to his/her Power BI dashboard, applies a filter by selecting California cases, and saves the bookmark. User 1 navigates to DNN website and Single Sign-On using his Azure AD credentials. User 1 can access saved bookmarks (show only California stats) after successful SSO.
User 2 [janedoe@onmicrosoft.com] logs in to his/her Power BI dashboard, applies the filter by selecting the cases for New York, and saves the bookmark. User 2 visits the DNN website and performs SSO using his Azure AD credentials. User 2 can access saved bookmarks (show only New York stats) after successful SSO.
Join our Partners Program
Join our trusted community of Partners and Resellers for ASP.NET solution. Our program provides exclusive benefits and updates which help you to serve your clients to grow their business.
Join Now
Trending searches:
Hello there!
Need Help? We are right here!
