Have you ever needed to measure the satisfaction of your Power BI audience? Do they like your reports? Are they unhappy?
The simple solution is to add a link to an external survey in your reports, but this approach will not get you a high rate of responses from your audience. Nobody likes answering surveys. A simple thumbs up/down or smile/frown control would be the best.
If you have the time and technical skills, you can manually implement such a control in Power BI using the Power Automate integration. Such technique was demonstrated back in 2022 by Guy in a Cube. But how would you collect feedback from many reports? Would you need to manually implement each report separately? How would you collect all the data and analyze it?
With BI Pixie you can automatically add feedback controls in as many reports you would need and analyze the user satisfaction like a pro. Starting from this week, BI Pixie is not only the best engagement tracking and measurement solution for Power BI, it can now measure user satisfaction on a large scale and help optimize the effectiveness of your BI portfolio.
To start collecting user feedback BI Pixie can instrument your target reports and add a feedback control in the first page of your Power BI reports.
Once the feedback collection is enabled, BI Pixie instruments a Bookmarks Navigator at the top right corner of the first page of the target reports. This control is used to collect user feedback. It consists of two or three bookmark buttons: A left-button for positive feedback, a right-button for negative feedback and an optional center-button for neutral feedback.
Option 1: [????] [????]
Option 2: [????] [☹️]
Option 3: [????] [????] [☹️]
Option 4: Any other icons you choose for positive, neutral and negative buttons.
When a report consumer clicks in one of the feedback buttons, the relevant bookmark selection event is sent to your deployment of BI Pixie on Azure or Power Platform. The same user can click the bookmarks multiple times. Later, during the analysis phase, you will be able to review the user satisfaction.
When the feedback control is set to show only two buttons (positive and negative), the neutral button is hidden, but it selected by default. Report consumers can select the positive or negative button, and then unselect it. The unselecting event will trigger under the hood the invisible selection of the neutral button, and the neutral feedback be tracked by BI Pixie.
After you instrument your reports, you can analyze the user satisfaction in BI Pixie Power BI App that is available on Microsoft AppSource.
With the User Satisfaction metrics below that are available in the semantic model of BI Pixie Power BI App, and combined with the engagement metrics, you can truly know your BI audience and optimize your reports.
| Metric | Description |
|---|---|
| Feedback clicks | The number of clicks in the Feedback control. In a report where the feedback control is instrumented, the same user can click the control multiple times. All these clicks will be counted. |
| Positive clicks | The number of clicks in the positive button of the Feedback control (e.g.???? or ????). |
| Negative clicks | The number of clicks in the positive button of the Feedback control (e.g.???? or ☹️). |
| Satisfied users | The number of users whose last click was positive in the selected reports |
| Dissatisfied users | The number of users whose last click was negative in the selected reports |
| CSAT (last response) | The count of positive responses (last response per user and report) divided by all last feedback responses in the specified time period. |
| CSAT (multiple responses) | The count of all positive responses, including multiple responses per user, divided by all feedback responses in the specified time period. This measure is also labeled as “CSAT (include same-user’s multiple clicks)” in the User Satisfaction page of BI Pixie Power BI app. |
| Average satisfaction | A number between -1 (negative) and 1 (positive) that is the average of all non-neutral feedback clicks. 0 means that the number of negative clicks equals to the number of positive clicks. |
| Respondents | The count of users who provided feedback – including neutral. |
| % Feedback responses | The percentage of feedback providers relative to all report consumers. |
Learn more about this feature in BI Pixie in this article.
Learn about BI Pixie here. I am looking forward to meeting you for a live demo ????
