Forum Discussion
Matthew_Balch
6 years agoFrequent Visitor
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...
GilbertQ
6 years agoSuper User
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?
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
6 years agoFrequent Visitor
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.
- GilbertQ6 years agoSuper UserYeah 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.