Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Experts
I created a Power BI presentation using a excel file that contain many sheets inside. (All sheets are of the same format)
Every month I will add in a new sheet but when I refresh Power BI the new month's data will not appear inside my query.
Is there a better way to do this then to create a new report every month?
If yes please help me why showing me the steps to do it!
Thank you in advance and let me know if my explanation is not clear enough =D
Solved! Go to Solution.
@Yuiitsu -
At this point, you can copy and paste visuals between your old report and your new report. Alternatively, make a copy of your existing report. Open it. In the new report with the Folder query, go into Query Editor, Advanced Editor copy the code. Go into the copy of your old report, Query Editor, find your query, Advanced Editor, Select All, paste in the code.
Yes, publish each Excel file as a new file with the same sheet. Use a Folder query to ingest all of the Excel files and append them together.
@Greg_Deckler Forgive me if I misunderstood your message.
Does this mean I do not have to redo the entire report again?
If not do you mind if you can further explain "Use a Folder query to ingest all of the Excel files and append them together." this step?
I am new to Power BI and still not familier with alot of terms and usage.
Thank you!
@Yuiitsu -
At this point, you can copy and paste visuals between your old report and your new report. Alternatively, make a copy of your existing report. Open it. In the new report with the Folder query, go into Query Editor, Advanced Editor copy the code. Go into the copy of your old report, Query Editor, find your query, Advanced Editor, Select All, paste in the code.
Refer for last update
https://powerbi.tips/2016/06/loading-data-from-folder/
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
I have figured it out actually...
The new sheet has to be added at the back of the excel sheet and not the front.
Problem solved! Thanks for all the additional info!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |