Forum Discussion

shon_tytus's avatar
shon_tytus
Frequent Visitor
1 year ago
Solved

Tracking and Storing Power BI Visual Changes in Excel with Timestamped Data Capture

Develop a mechanism within Microsoft Excel that connects to a Power BI report and/or dataset, enabling users to track changes in a Power BI report visual’s value over time, this solution would gather...
Need Help
  • v-csrikanth's avatar
    v-csrikanth
    1 year ago

    Hi shon_tytus 
    If you feel issue got resolved please accept as a solution. 

    If you're still experiencing new challenges, please feel free to let us know and we'll be happy to continue to help!
    Looking forward to your reply!

    Best Regards,
    Community Support Team _ C Srikanth.


     

    Best Regards,
    Cheri Srikanth 

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi shon_tytus 
Would you mind sharing the approach you used to resolve the issue? It would be helpful to others facing a similar situation.
If possible, kindly post your solution in this thread so the community can benefit from it. Thanks again for your contribution!

Best Regards,
Cheri Srikanth 

shon_tytus's avatar
shon_tytus
Frequent Visitor
1 year ago

Hi,
I have taken the approach of copying the query for a particular card or visual from the Performance Visualizer in a Power BI report and running a Power Automate flow to save the Excel file to a specific location. From there, we use Python to extract the necessary data points from the Excel file.