'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Connect Power BI to Viva Goals for OKR Reporting
Question details
The user needs to extract OKR data from Viva Goals into Power BI to build custom reporting dashboards.
- Product
- Power BI / Viva Goals
- Device & OS
- not provided
- Scenario
- Creating automated OKR reporting dashboards using data imported from Viva Goals.
- Observed behavior
- Requires verifying available data connectors, APIs, or export capabilities as native dashboard integration might not be immediately visible.
Verify your Microsoft tenant permissions and ensure you have administrative access to both Power BI and Viva Goals to configure new data connections.
Verify Connectors and Consult the Power BI Community
Determine if your tenant supports a direct data connector, an API integration, or if you need community assistance for custom OKR data extraction.
While Power BI can update Viva Goals objectives through certain connections, pulling Viva Goals data back into Power BI for dashboarding requires specific connectors or APIs.
Microsoft frequently updates its integration ecosystem, so the best approach is to check the official 'Get Data' list and consult experts for customized API scripts.
Open Power BI Desktop, click on 'Get Data', and search for 'Viva Goals' to see if a native connector has been deployed to your tenant.
Consult the official Microsoft Viva Goals data access and integration documentation to check for newly supported APIs or OData feed options.
Navigate to the Microsoft Power BI Community forum (community.fabric.microsoft.com) and post your specific tenant scenario to request custom API scripts or integration workarounds.
If no automated connector is available, export your OKR data from Viva Goals as an Excel or CSV file and manually import it into Power BI via the 'Get Data' > 'Text/CSV' option.
Manage Your OKR Reports with WPS Office
If you are exporting OKR data to CSV or Excel formats, WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for building intuitive data reports and dashboards.
- 1. Export OKR Data: Export your current OKRs from Viva Goals as a CSV or Excel file.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open your downloaded OKR data file.
- 3. Create a Dashboard: Use WPS Spreadsheet's pivot tables and diverse charting options to build a customized, lightweight OKR tracking dashboard.
Frequently Asked Questions
Is there a direct Viva Goals connector in Power BI?
Availability of a native Viva Goals connector in Power BI depends on your tenant's update cycle and permissions. Always check the 'Get Data' menu in Power BI Desktop for the most current options.
How can I report on Viva Goals data if there is no native connector?
You can export your OKR data directly from Viva Goals into an Excel or CSV file format. Once exported, you can import those files into Power BI or another spreadsheet software to build your reports.
Where can I find custom API scripts to automate Viva Goals data extraction?
The Microsoft Power BI Community (community.fabric.microsoft.com) is the best resource for finding custom Power Query scripts, API configurations, and community-tested solutions for extracting Viva Goals data.
