Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all @needhelp @camargos88
I have single dataset in excel and using that i loaded into power bi and made visualization but ill recieve same file monthly so i need to refresh or append the newly recieved excel file.
kindly suggest your answer please.
Regards
@Dhanasurya-98
Solved! Go to Solution.
@Anonymous
So the excels have the same columns and schema just different date and value. With this condition, try the following:
1. If you only need to see the new excel data, you can replace the new excel name to the connected excel name. For example, you have connected a excel file named CurrentMonth, every month you receive a new excel, you can change this old excel to Year and Month (2020May), and change the new excel to CurrenMonth. Power bi will refresh the data in the new file named current month.
2. Another way you can try is get data from folder, please refer to this tutorial. You just need put the new received excel to the connected folder.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
So the excels have the same columns and schema just different date and value. With this condition, try the following:
1. If you only need to see the new excel data, you can replace the new excel name to the connected excel name. For example, you have connected a excel file named CurrentMonth, every month you receive a new excel, you can change this old excel to Year and Month (2020May), and change the new excel to CurrenMonth. Power bi will refresh the data in the new file named current month.
2. Another way you can try is get data from folder, please refer to this tutorial. You just need put the new received excel to the connected folder.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What is the data source for the monthly file? Simplest is to use Get Data From Folder, but depending on what changes with that monthly dataset you may also want to look at parameters.
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
Use Parameters to Combine Data
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |