Manual Data Entry

[peteru9067]

I have my dashboard pulling Plant Trips data from OSI PI (PI Server on a 24hr refresh rate) which only includes the IPL Tag column and Date Column. A review team will review, validate and assign a classification to the trip i.e. "Process Trip" or "Spurious Trip" and provide comments. This process has to be MANUAL ENTRY. 

For Example:

In the table below I will like to create a couple of columns one for "Status" and the other for "Comments" so that when the data is pulled in from PI (which only includes IPL Tag and Date), after a review team has performed an investigation, the team can now assign values such as "Process Trip" or "Spurious Trip" to the tags for the Status Column and "Comments" to the Comment Column. This process must be done MANUALLY because there is no where the control system can determine the status and provide justification.

IPL Tag	Date	Status	Comments
130-PXSHH-2004A	5/9/2022
171-LSHH-0314	5/8/2022
177-TXSHH-0018	5/10/2022
120-VXSHH-0001	5/8/2022

[Anonymous]

H @peteru9067,

AFAIK, the current power bi does not include writeback features. For your requirement, you need to use other features to send these motions to your data source. (e.g. power apps)

Power Apps visual for Power BI - Power Apps | Microsoft Docs
>>What happens when the PI data is refreshed every 24hrs? Will it keep the information I uploaded with the PowerApp?

You also need to get data from the data source that use to save review and validate information to your bi report and reference these records to your fact table custom column. Then power bi update operations will also update these records if you sent the changes to the data source.

Regards,

Xiaoxin Sheng

[peteru9067]

Thanks for the reponse...... There isn't a fact table; once a team review and evaluate the actual trip tag, then that tag is entered into an excel page which I now use for the Power BI.......

[amitchandak · Accepted solution]

@peteru9067 , If you want to do you can use enter Data.

If you want the end-user to do that, You need to use the power app

https://www.youtube.com/watch?v=LxuRzj0X348

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...

[peteru9067]

Thanks....... What happens when the PI data is refreshed every 24hrs? Will it keep the information I uploaded with the PowerApp?