Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
Let's say for every time a new csv file or excel file comes in having same columns, I would like to make exactly same charts (such as scatter plots or bar charts) with the same methdology and generate a report.
Is there a way to automate that process? I've searched through but didn't find anything close to that.
I am not even sure if that exisits in PowerBI. Any directions or suggestions are welcome and appreciated.
Thanks.
Solved! Go to Solution.
HI @Anonymous ,
In that case, yuo can just go to File--> Options and Settings -->Data Source Settings, modify the path od your csv files and apply chnages.
This will refresh data for your report.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
HI @Anonymous ,
Your requirement is not clear to me.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
The first one:
To update the existing Power BI report with new data files
HI @Anonymous ,
In that case, yuo can just go to File--> Options and Settings -->Data Source Settings, modify the path od your csv files and apply chnages.
This will refresh data for your report.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hey @Pragati11, thanks a lot, it works!
I am also curious about the second one (adding new rows), in case there's a need in the future.
Hi @Anonymous ,
For the second scenario, you can append data in Query editor to your existing files.
You can refre the following article for this:
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
User | Count |
---|---|
77 | |
76 | |
44 | |
31 | |
26 |
User | Count |
---|---|
98 | |
89 | |
52 | |
48 | |
46 |