Forum Discussion
Automate data entry in excel
Hello All,
I have a requirement. If anyone has any idea, please help.
Scenario:
A user has an Excel file where she manually fills data. The Excel file is stored on her local system. The data she enters is taken from other Excel files that she receives from different clients. She reviews the Excel files received from clients, extracts the required data, and then manually fills it into her local Excel file. Later she uses the excel in power bi as source
Is there any way to automate the data filling in the Excel file on her local system?
hI Bharathi0909
Should be possible if her other sources are excel files. In Excel, you can use powerquery to pull from other sources and Extract, Transform, and Load (ETL).
4 Replies
hI Bharathi0909
Should be possible if her other sources are excel files. In Excel, you can use powerquery to pull from other sources and Extract, Transform, and Load (ETL).
Hi! Bharathi0909
You can directly use that excel that her client sends and maybe if the logic is known you can use that in Power BI directly. So she doesn't have to fill in data manually into local file.
Also, yes this can be automated through Power Automate or VBA codes.
Hi Bharathi0909,
Thank you for reaching out to Microsoft Fabric Community.
Thank you hnguy71 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Hi @Bharathi0909,
We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
