Forum Discussion

Maxwell_SFMFB's avatar
Maxwell_SFMFB
Copper Contributor
Oct 17, 2024

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. 

best practices
Key Results
kpi
Office Hours
  • aarushiarora's avatar
    aarushiarora
    Icon for Microsoft rankMicrosoft
    Oct 28, 2024

    Hi Maxwell_SFMFB, while directly querying Viva Goals data from Power BI is not supported at this time, there are two other options you can leverage to bring Goals data in Power BI reports: 

    1. APIs – You can use OKR export APIs to schedule automatic exports and feed this Excel file as input to Power BI
    2. Power Automate – You can use HTTP actions in Power Automate to achieve the same export and store the OKR files in SharePoint and connect it with Power BI.

Resources