Power BI Report Embedding with MemberPress Integration

This integration allows you to embed Power BI reports and dashboards on your WordPress site while managing access based on MemberPress membership levels.

 

Why?

Managing user access to Power BI reports can be challenging when using WordPress. This integration ensures:

  • Seamless report embedding for logged-in users.
  • Membership-based access control.
  • Advanced security with Row-Level Security (RLS) where you can map your MemberPress membership levels with your RLS roles.

 

Solution

This feature simplifies access management by integrating MemberPress with the Power BI plugin, allowing you to restrict access and map RLS roles for secure and customized data views.

 

License Requirement

To enable this feature, you need an Enterprise version Power BI Embed Report Plugin license by miniOrange and MemberPress plugin set up on your WordPress site.

 

How to Integrate Power BI with MemberPress?

Follow the below steps to Integrate Power BI with MemberPress:
Step 1: Generate the Power BI Shortcode

  1. Go to the Power BI tab in the plugin.

  2. Click on the + button to create a new shortcode.

    Add Shortcode

  3. Enter the required details such as Report Name, Workspace ID, and Report ID.

    Add Shortcode Details

  4. Once the details are entered, locate the Report has access to section.

    • Here, you will see the MemberPress membership levels (ensure you have already created these levels in the MemberPress plugin).

      MemberPress UI
       
      Select Membership Levels

  5. Give Access Based on Membership Levels:

    • Simply select the membership level to which you want to provide access to the report.

      Select Membership Levels to Provide Access to Report

    • After selecting (here we have selected GOLD), generate the shortcode.

      Generate Shortcode

    • Copy and paste the shortcode onto a WordPress page or post.

      Paste Generated Shortcode in WP Pages/Posts

    • Now, only users with the selected membership levels will be able to view the Power BI report.

  6. Map Membership Levels with RLS (Row-Level Security)

    • Once membership levels are selected, turn on the toggle to Enable RLS (Row-Level Security) settings.

      Enable RLS (Row-Level Security)

    • You will see the Roles/Memberships-RLS Mapping input fields on the right-hand side under the section Roles/Memberships-RLS Mapping.

      Roles/Memberships-RLS Mapping

    • Enter the RLS roles you want to map with the selected membership levels.

      Enter RLS roles

    • Save the shortcode after completing the mapping.

 

Step 2: Embed the Shortcode

  1. Copy the generated shortcode.

  2. Paste it into any WordPress page or post.

  3. Publish the page.

 

Step 3: Verify Access
  1. Users with the specified membership levels will now see the report with data filtered by the mapped RLS roles.

 

You’ve successfully restricted Power BI reports and enabled RLS mapping based on MemberPress levels!

For more information visit our WordPress Embed Power BI Reports page or mail us at office365support@xecurify.com.