Power BI User Feedback Pro
Collect real-time feedback directly in Power BI to optimize your dashboards and enhance user satisfaction
“Your data stays secure: All feedback is stored and analyzed within your enterprise Azure environment, ensuring compliance and privacy“
Power BI User Feedback Pro is a custom visual designed to empower dashboard creators by collecting real-time user feedback directly within Power BI. This visual allows users to rate dashboards on a 1-5 star scale and leave detailed comments, enabling actionable insights. The feedback data is seamlessly integrated with an Azure Application Insights instance for comprehensive analysis.
Key Benefits of Power BI User Feedback Pro
Real-Time Feedback Collection: Users can provide ratings and comments directly within dashboards.
Azure Application Insights Integration: Store and analyze feedback with advanced telemetry tools.
Customizable Options: Configure feedback properties like ratings scale, comments, and layout.
Enhanced Dashboard Usability: Gather insights to continuously improve your Power BI reports.
Requirements
To set up **Power BI User Feedback Pro**, you’ll need:
Access to Power BI Desktop and a Power BI license.
An Azure Application Insights resource to collect and store feedback data.
Permission to configure the Power BI report and access Azure App Insights services.
How to Use the User Feedback Visual in Power BI
Step 1: Install the Visual from AppSource
Open Power BI Desktop.
In the Visualizations pane, click the ellipsis (`...`) at the bottom of the pane.
Select Get more visuals.
This will open the Power BI Visuals Marketplace (or AppSource as alternative).
Search for "User Feedback" by Altoro Analytics.
Click Add to install the visual to your Power BI environment.
Once installed, the User Feedback visual will appear in your Visualizations pane.
Step 5: Interacting with the Visual
After the visual is added to the report, users can:
Rate Items: Click on the stars to provide a rating (from 1 to 5 stars). The rating is instantly captured.
Provide Feedback: Once a rating is selected, a feedback dialog will open, allowing the user to enter additional comments or suggestions.
Submit Feedback: The user submits the feedback, and both the rating and comments are logged for further analysis.
Use Cases
- Product Feedback: Collect ratings and comments on products or services.
- Employee Engagement: Gather feedback from employees on internal reports or dashboards.
- Customer Feedback: Use this visual in customer-facing reports to collect valuable feedback and insights.
Application Insights Integration
To enable Application Insights tracking, you'll need an Application Insights connection string. This integration allows you to monitor and track feedback and rating events in real-time.
How to Set Up Application Insights:
Using Power BI Feedback Pro requires an Azure Application Insights instance. This is essential for storing and analyzing the feedback collected from your dashboards. Follow these steps to get started:
Set Up Azure Application Insights
If you don’t already have an Application Insights resource, create one in your Azure Portal.
Click here for a step-by-step guide on creating an Application Insights resource.
Obtain Your Application ID and API Key
Once your Application Insights resource is set up, retrieve your:
Application ID from the “API Access” section in the Azure Portal.
API Key with the necessary permissions to allow data tracking.
Configure the Feedback Visual in Power BI
Open your Power BI report and add the Power BI Feedback Pro visual.
In the visual’s configuration pane:
Enter your Application Insights Connection String.
Customize the visual settings (e.g., number of stars, feedback dialog).
Validate Your Configuration
Publish the dashboard and test the feedback visual to ensure that the data flows into your Application Insights instance.
What gets logged?
Rating: The star rating submitted by the user.
Feedback: Any text or comments entered in the feedback dialog.
User Information: If configured, the user's identity (e.g., username or user ID) can be logged along with the feedback.
---
Analyzing the usage data
Using Application Insights
All the user feedback and ratings are sent to Application Insights as custom events. Two types of custom events are created:
rating: A custom event gets created when a user submits a new rating. This custom event contains two custom dimensions: `rating` and `maxRating`.
feedback: A custom event that represent textual feedback submitted by a user. The feedback can be found in the custom dimension `feedback`.
You can identify the type of custom event by using the prefix of the event `name` or the custom dimension `eventType`.
For more information regarding usage analysis with Application Insights follow the link below:
Usage analysis with Application Insights : https://learn.microsoft.com/en-us/azure/azure-monitor/app/usage-overview
NOTE: Application Insights will not analyze user sessions across different reports and report pages, in order to do that one must write custom Kusto queries against the Log Analytics workspace.
Writing custom Kusto queries (KQL)
Using your own Kusto queries against the data collected in the Log Analytics workspace enables one to export the feedback for further processing. You can run the following two queries to select the latest `feedback` and `rating` events, and then export them to a CSV file or connect from Power BI through API request.
Rating query:
——————————————————————————————————————————————————-
customEvents
| where timestamp > ago(90d) and customDimensions.eventType == "rating"
| order by timestamp desc
| project timestamp, user_AccountId, customDimensions.trackerName, customDimensions.reportId, customDimensions.sectionId, customDimensions.rating, customDimensions.maxRating
——————————————————————————————————————————————————-
Feedback query:
——————————————————————————————————————————————————-
customEvents
| where timestamp > ago(90d) and customDimensions.eventType == "feedback"
| order by timestamp desc
| project timestamp, user_AccountId, customDimensions.trackerName, customDimensions.reportId, customDimensions.sectionId, customDimensions.feedback
——————————————————————————————————————————————————-
For more information about how to write your own Kusto queries:
Kusto Query Language (KQL) overview: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/
Troubleshooting
If you're encountering issues with the User Feedback visual, consider the following troubleshooting steps:
Visual Not Displaying: Ensure the visual has been successfully added from AppSource and is selected in the Visualizations pane.
Feedback Not Logged: Double-check that the Application Insights connection string is correctly entered and that your Application Insights resource is active.
No Rating or Feedback Submitted: Ensure the user is selecting a rating and submitting the feedback dialog. If the dialog does not appear, check that the Show Feedback Dialog setting is enabled.
Blank AccountId in Logs: Make sure the model has been setup with a new measure the returns the user name, and that the measure name matches the one specified in the configuration of the visual..
Licensing and Pricing
Power BI Feedback Pro follows the same licensing model as other Power BI visuals available on Microsoft AppSource, ensuring a seamless and trusted process for organizations.
Licensing Through Microsoft AppSource
Licensing is handled directly through Microsoft, just like Power BI itself.
Simply choose the plan that fits your organization, and activate it via your Microsoft 365 account.
Billing and management are integrated into your existing Microsoft ecosystem, making it easy to track and control costs.
Licensing Tiers
We offer three scalable plans:
Small Team Plan
User Range: 1-100 users.
Annual Cost: $12 per user.
Best for startups or small teams starting to collect feedback from dashboards.
Business Plan
User Range: 101-500 users.
Annual Cost: $5 per user.
Ideal for medium-sized businesses with multiple teams using dashboards.
Enterprise Plan
User Range: 500+ users.
Annual Cost: $4 per user.
Perfect for large enterprises managing extensive reporting infrastructures.
How to Get Started
Download Power BI Feedback Pro from Microsoft AppSource.
Select the licensing plan that matches your organization’s needs.
Activate the visual within your Power BI dashboards and start gathering actionable insights.
Key Advantages of Microsoft Licensing
Seamless Integration: Use your existing Microsoft 365 account for easy activation and management.
Trusted Billing: Licensing and payments are handled securely through Microsoft’s infrastructure.
Scalability: Quickly adjust your licensing tier as your organization grows or changes.
📩 Have Questions? Contact us at contact@altoroanalytics.com for more details or custom solutions.
FAQs
How do I change the number of stars in the rating system?
You can adjust the number of stars by changing the Number of Stars setting in the Formatting Pane. The default is 5 stars, but you can set it to any number that fits your needs.
Can I customize the size of the stars?
Yes, the Star Size can be customized using the Star Size setting in the Formatting Pane. You can make the stars larger or smaller to suit your design preferences.
How do users submit feedback?
After selecting a rating, the visual opens a feedback dialog where users can enter their comments. The feedback is submitted once the user finishes typing and closes the dialog.
Is the User Feedback visual customizable?
Yes, you can customize the visual in several ways, including the number of stars, star size, feedback dialog settings, and whether feedback events are logged to Application Insights.
Support
For assistance or to report issues with the User Feedback visual, please contact Altoro Analytics Support or consult your Power BI administrator
contact@altoroanalytics.com
Screenshots:
Step 2: Add the Visual to Your Report
After the visual is installed, drag the User Feedback visual from the Visualizations pane to your report canvas.
Resize and position the visual as needed.
Step 3: Setting up the Model
Before utilizing Power BI User Feedback, the report's model needs a modification to include a measure that will help identify the user submitting the feedback.
Use DAX functions like `USERNAME()`, `USERPRINCIPALNAME()`, or `USEROBJECTID()` to create a measure that returns the current user.
For example:
$USERNAME = USERNAME()
Make sure the name of the measure matches the one specified in the configuration settings in the next step.
Step 4: Configure the Visual
You can configure the User Feedback visual using the Formatting Pane to customize its appearance and functionality.
Select the User Feedback visual on your report canvas.
In the Visualizations pane, click the Format button (paint roller icon).
Use the following settings to customize the visual:
General Settings- Feedback Name: Set a custom name for the feedback (e.g., "Product Rating" or "Dashboard Feedback").
- Account ID Measure: Specify the measure that identifies the user (e.g., username or user ID). This is helpful for tracking who provides feedback.
- Log to Console: Toggle whether to log feedback events to the browser console (useful for debugging).
- Number of Stars: Set the number of stars available for rating (e.g., 5 stars).
- Star Size: Adjust the size of the stars.
- Show Feedback Dialog: Toggle whether the feedback dialog appears after the user submits a rating.
- Application Insights Connection: Enter an Application Insights connection string to log rating and feedback events (optional). (next image shows how to get the connection string from your App Insights)
