Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
bklosowski
Frequent Visitor

Record and Store Current Measure Value

Hi everyone, 

 

I am using PowerBI to monitor the total length of modelled piping in an engineering project. As our designers continue to model more pipes each day, this value is always increasing.

 

To maintain a record of this data over time, I currently use a small CSV file where I manually input the measurement from PowerBI along with the date, each morning. E.g:

 

Date ______ | _ MeterageInModel
18/02/2023 | 1100
19/02/2023 | 1200
20/02/2023 | 1300
21/02/2023 | 1400
22/02/2023 | 1500

 

I wonder if it is possible to automate this process. For example, by using a Python script that is triggered each time the report is refreshed? Maybe Pandas could export this calculated value as a new line in an external CSV. Does that make sense? 

Thank you very much. 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors