Capture KPIs data so I can track

[Matthew_Balch]

I have a multitude of business KPIs (hundreds when looking top to bottom), I'd like to capture these from Power BI on a daily basis and track - put in a graph vs target to see if improving or not etc.

Possibly some sort of write back to an excel file?

Thanks

Matt

[Matthew_Balch]

Thanks for the answers - my issues lies in the fact I dont have a data warehouse. I am pulling live data all the time from various sources, so all the KPIs are live. I have no way of recording the history / tracking of these KPIs. What I wanted to explore was recorded the KPIs as shown in Power BI at the end of the day? NB write the KPIs from Power BI to an Excel table.

[v-yingjl]

Hi @Matthew_Balch ,

You can import these data into power bi desktop and try to use the 'KPI' visual. Also, you can put them in a table visual, when the data refreshes, you can export data as a .csv file to set up as comparison.

Here are some articles about KPI that hope to help you too:

1. Create key performance indicator (KPI) visualizations 
2. Key Performance Indicators (KPIs) in PowerPivot 
3. Key Performance Indicators : Your Guide to Power BI KPI 
4. KPIs in Power BI 

Best Regards,
Yingjie Li

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

[GilbertQ]

Hi there

yes you could use Excel which is stored in OneDrive for business which you could then use to import into your PBIX?

Or you could use a Power App?

Or you could use another really good product called Power On?

[Matthew_Balch]

I did look at Power ON, as well another one in the market place, however, my first block is that I am working in a web of spreadsheets so first step would be migrating into SQL server myself. 

[GilbertQ]

Yeah I would suggest starting there, and then working your way back up.

Typically I see things always grow and grow, so if you can get it done right from the start you save a lot of time, effort and money later.