Forum Discussion

mtitsworthsfmfb's avatar
mtitsworthsfmfb
Frequent Visitor
1 year ago
Solved

Power BI Extract Viva Goals Data - Suggestion

It would be great if we could query Viva Goals data using Power BI. This would enable much more flexible reporting of our organization performance and would enable a consistent user experience for our users using other Power BI dashboards. 

2 Replies

  • Hi mtitsworthsfmfb - The idea of enabling Power BI to query Viva Goals data is a compelling one and could bring substantial value to organizations by allowing more flexible and comprehensive reporting of organizational performance. Viva Goals is a part of Microsoft's Viva suite, focusing on objectives and key results (OKRs). Integrating Viva Goals data into Power BI could enhance your organization's ability to track OKRs alongside other performance metrics, creating a unified reporting experience.

    The integration could be done via APIs that allow Power BI to query Viva Goals data directly. As of now, there isn't direct API integration between Power BI and Viva Goals, but Microsoft is continuously updating its ecosystem, and adding such integrations is feasible.

    If you're interested in this, consider submitting a feature request through Microsoft Power BI's Ideas platform, as user feedback is often considered in the development of new features. Additionally, keeping an eye on Microsoft's updates to their Viva suite and Power BI integrations is recommended.

    Power BI - https://ideas.powerbi.com

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from rajendraongole1 , please allow me to provide another insight: 
    Hi  mtitsworthsfmfb ,

     

    You can try to establish a connection to Viva Goals data using the Power BI Desktop - Get data - Online Services - Viva lnsigths step.

    Use the Power BI connector | Microsoft Learn

    The following link is about the Power BI integration for Viva Goals:

    Key results and initiatives that use metrics to track completion in Viva Goals can directly connect to data from reports in Power BI. Viva Goals will sync the data at regular intervals, ensuring your key results and initiative always stay up to date with the latest progress.

    Power BI integration | Microsoft Learn

    Connect daily work to OKRs with our latest Viva Goals integrations - Microsoft Community Hub

     

    You can also consider using an ODBC connection, but this is generally specific to databases that do not have a direct connection method in Power BI:

    Connect to data using generic interfaces in Power BI Desktop - Power BI | Microsoft Learn

    How to Connect to an ODBC Data Source From Power B... - Microsoft Power BI Community

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.