What is Microsoft Power BI?
Microsoft Power BI is a powerful business tool that provides interactive visualisations and real-time dashboards for users to analyse and gain insightful reports from their survey data.
Why should I integrate Microsoft Power BI with Zoho Survey?
By integrating Zoho Survey with Microsoft Power BI, you can easily view survey responses directly in Power BI and gain valuable insights into their respondents' feedback.
Accessibility:
Microsoft Power BI integration feature is accessible to all paid pro plan users.
Note:
If you'd like to integrate Microsoft Power BI, kindly reach out to our support team at support@zohosurvey.com via email. We will send you the installable file upon request. Use cases:
1. Analyze survey data:
With Zoho Survey integration, survey data is imported directly into Microsoft Power BI, allowing you to create custom visualizations and analyze the data to identify trends, patterns, and insights.
2. Gain insights into customer behavior:
By conducting surveys using Zoho Survey and analyzing the data in Power BI, organizations can gain valuable insights into customer behavior, preferences, and satisfaction levels. These insights can help organizations improve their products and services to meet the needs of their customers.
3. Improve employee engagement:
Surveys can also be conducted amongst employees to gather feedback on job satisfaction, workplace culture, and management effectiveness. With Zoho Survey integration, survey responses can be analyzed in Power BI to identify areas for improvement and track progress over time.
4. Monitor event feedback:
Organizations can use Zoho Survey to gather feedback from attendees at events, then use Power BI to analyze the responses and gain insights into event satisfaction levels, popular sessions, and speakers.
To integrate Zoho Survey With Microsoft Power BI :
Go to Manage Portal> Apps & Services.
Scroll down and choose the PowerBI app and click CONNECT.
- Log in to your Microsoft Power BI account and navigate to the Get Data section.
- Search for and select Zoho Survey from the available data sources.
Enter your Zoho Survey account credentials to authorize the connection. Your Zoho Survey account and Microsoft BI account will be successfully integrated.
To View Survey Responses in Microsoft Power BI:
Sign in to your Microsoft Power BI account.
Click the Get Data Button in the left pane and select Zoho Survey from the list of available integrations.
A list of your Zoho Survey surveys will appear. Select the survey you want to view responses for and click the Connect button.
Zoho Survey - Power BI streaming dataset integration:
Sign in to your Microsoft Power BI account.
On the home page of your Power BI account, click on New under My Workspace.
Select Streaming semantic model.
In the New streaming dataset screen, select API and click Next.
Now, enter the Dataset name and other Values from stream.
Note: Stream values should be named without spaces.
Click on the Text dropdown and select the required type of input.
Enable Historic data analysis.
Click Create.
Copy the Push URL and click Done.
To create Zoho Survey - Power BI streaming dataset
Go to Hub.
Under Integrations, click Create/Manage in Power BI Streaming Dataset section.
Enter the name and paste the copied Push URL under POST URL.
Enter values matching as provided in your streaming dataset configuration under Power BI and select the required question from the questions dropdown.
To add a new value, click .
To remove an existing value, click .
Click Save.
To sync status under Zoho Survey - Power BI streaming dataset:
Open the required Power BI streaming data set and click on Sync Status.
Under Sync Status:
Click on Successful to view the successfully synced responses.
Click on to edit a response.
Click on to view a response.
Click on Untried to view the responses that are not synced.
Click on Sync to sync a particular response.
Click on Sync All to sync all responses.
Click on Failed to view the responses that failed to sync.
Click on Sync to sync a particular response.
Click on Sync All to sync all responses.
To edit a Zoho Survey - Power BI streaming dataset:
Go to Hub.
Under Integrations, click Manage in Power BI section.
Hover on the required integration and click .
To delete a Zoho Survey - Power BI streaming dataset:
Go to Hub.
Under Integrations, click Manage in Power BI section.
Hover on the required integration and click .
To deactivate Microsoft Power BI integration :
- You can deactivate Microsoft Integration at any time. Deactivation of the integration does not interfere with the Zoho survey account settings. You can continue to build surveys from your Zoho Survey account.
- Go to the Manage portal. Hover and navigate to the Microsoft Power BI app under the Apps and Services tab.
- Click the disconnect button, to remove the integration.
- A popup will appear asking what you would like to do with the existing data. Choose the appropriate option and click yes, Disconnect integration.