Power BI Report Embedding with Paid Memberships Pro Integration

This integration allows you to embed Power BI reports and dashboards on your WordPress site while managing access based on Paid Memberships Pro 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 paid membership pro membership levels with your RLS roles

 

Solution

This integration simplifies managing Power BI report access on WordPress by linking Paid Memberships Pro levels with report permissions. You can restrict access to specific membership levels, ensuring only eligible users can view the reports. With RLS (Row-Level Security), you can further secure data by mapping membership levels to RLS roles, filtering report data based on user roles. The plugin allows easy generation of shortcodes with these settings, which can be embedded on WordPress pages or posts. This ensures seamless, secure, and scalable access control for your Power BI reports.

 

License Requirement

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

 

How to Integrate Power BI with Paid Memberships Pro?

Follow the below steps to Integrate Power BI with Paid Memberships Pro:
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 Restrict Action section.

    • Here, you will see the Paid Membership Pro levels (ensure you have already created these levels in the Paid Membership Pro plugin).

      Paid Membership Pro UI
       
      Paid Membership Pro 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, 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.

    Copy Generated Shortcode

  2. Paste it into any WordPress page or post.

    Paset Generated Shortcode into WP Pages/Posts

  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 Paid Membership Pro levels!

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