Integrating customer feedback to Dataverse and embedding Power BI Visualizations into Power Pages: A Step-by-Step Guide

In the realm of data visualization and web development, the integration of Power BI with Power Pages offers a powerful combination. This integration allows you to embed interactive and insightful Power BI reports and dashboards directly into your Power Pages websites, providing users with a seamless and data-rich experience. This blog will walk you through the process of integrating Power BI visualizations into Power Pages.

Integrating Forms in Power Pages for Customer Feedback

Power pages uses Dataverse as the data source and can add tables in power pages as forms or lists. The table fields can be customized and embed as forms on power pages. The permissions can be configured using page settings, table permissions and web roles. The power pages can be created either from template or from blank pages. The table to be included as part of power pages can be selected from the list of Dataverse tables.

Once the table is selected, the fields to be included as part of forms can be configured as shown below.

The form added can be seen in power pages and customers will be able to provide their feedback as well.

The entered data in forms gets saved in Dataverse. The visualization of the data entered can be created using Power BI. The feedback of the customers can be analysed using AI builder using Sentiment analysis.

Why Integrate Power BI with Power Pages?

Power BI is renowned for its robust data visualization capabilities, while Power Pages (formerly known as Power Apps portals) enables you to create secure, data-driven websites. By integrating these two platforms, you can:

• Enhance User Experience: Provide users with interactive and real-time data visualizations directly on your website.
• Improve Decision-Making: Enable users to make informed decisions based on the latest data insights.
• Streamline Data Access: Allow users to access and interact with data without leaving the website.

Prerequisites

Before you begin, ensure you have the following:

• A Power BI Pro or Power BI Premium license.
• A Power Pages site.
• Relevant data stored in Microsoft Dataverse.
• Power BI Desktop installed on your computer.

Steps to Integrate Power BI with Power Pages

1. Enable Power BI Visualization in Power Pages:

• • • Open the Power Platform admin center.
    • Navigate to Resources and select Power Pages sites.
    • Choose the site where you want to enable Power BI visualization.
    • Select Manage from the main menu.
    • In the Services section, enable the Power BI Visualization toggle.

2. Prepare Your Power BI Report:

1. 1. • Create or open your Power BI report in Power BI Desktop.
      • Ensure your report is published to the Power BI service.
      • Configure any necessary row-level security (RLS) to ensure users see only the data they are authorized to view.

3. Embed Power BI Report in Power Pages:

1. 1. • In Power Pages, navigate to the page where you want to embed the Power BI report.
      • Use the powerbi Liquid tag to embed the report. The syntax is as follows:

HTML

{% powerbi id:”<report-id>” %}

1. 1. • Replace <report-id> with the actual ID of your Power BI report. You can find this ID in the URL of your report in the Power BI service.

4. Configure Filters and Parameters:

1. 1. • You can pass filters and parameters to the Power BI report to create personalized views for users. For example:

HTML

{% powerbi id:”<report-id>” filter:”<filter-parameter>” %}

1. 1. • This allows you to dynamically filter the data based on user interactions or other criteria.

5. Test and Publish:

Preview the page to ensure the Power BI report is embedded correctly and displays the expected data.

• • • Publish the changes to make the report available to your users.

Benefits of Integration

• Interactive Data Exploration: Users can interact with the data directly on the website, drilling down into details and exploring different visualizations.
• Real-Time Insights: Power BI reports provide real-time data updates, ensuring users always have access to the latest information.
• Secure Data Access: With row-level security, you can control data access at a granular level, ensuring users see only the data they are authorized to view.

Conclusion

As Power pages used Dataverse as the data source, there are no extra configurations required for saving data in Dataverse. Integrating Power BI visualizations into Power Pages is a game-changer for organizations looking to provide rich, interactive data experiences on their websites. By following the steps outlined above, you can leverage the strengths of both platforms to deliver powerful insights and enhance user engagement.

About CloudThat

CloudThat is a leading provider of Cloud Training and Consulting services with a global presence in India, the USA, Asia, Europe, and Africa. Specializing in AWS, Microsoft Azure, GCP, VMware, Databricks, and more, the company serves mid-market and enterprise clients, offering comprehensive expertise in Cloud Migration, Data Platforms, DevOps, IoT, AI/ML, and more.

CloudThat is the first Indian Company to win the prestigious Microsoft Partner 2024 Award and is recognized as a top-tier partner with AWS and Microsoft, including the prestigious ‘Think Big’ partner award from AWS and the Microsoft Superstars FY 2023 award in Asia & India. Having trained 650k+ professionals in 500+ cloud certifications and completed 300+ consulting projects globally, CloudThat is an official AWS Advanced Consulting Partner, Microsoft Gold Partner, AWS Training Partner, AWS Migration Partner, AWS Data and Analytics Partner, AWS DevOps Competency Partner, AWS GenAI Competency Partner, Amazon QuickSight Service Delivery Partner, Amazon EKS Service Delivery Partner,  AWS Microsoft Workload Partners, Amazon EC2 Service Delivery Partner, Amazon ECS Service Delivery Partner, AWS Glue Service Delivery Partner, Amazon Redshift Service Delivery Partner, AWS Control Tower Service Delivery Partner, AWS WAF Service Delivery Partner, Amazon CloudFront, Amazon OpenSearch, AWS DMS and many more.

To get started, go through our Consultancy page and Managed Services Package, CloudThat’s offerings.