Forum Discussion

Matthew_Balch's avatar
Matthew_Balch
Frequent Visitor
6 years ago

Capture KPIs data so I can track

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

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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's avatar
      Matthew_Balch
      Frequent Visitor
      6 years ago

      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's avatar
        GilbertQ
        Super User
        6 years ago
        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.
  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.

  • Matthew_Balch's avatar
    Matthew_Balch
    Frequent Visitor
    6 years ago

    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.