Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
For a problem tickets , i have a extraction via web query . my requirement , every month i need to download last month appended to existing data. how to achieve it
table partition ? archive table ?
Solved! Go to Solution.
Power BI itself doesn't retain historical data between refreshes. Each refresh pulls the latest data from the source, which means historical data will be overwritten unless stored elsewhere. If this happens just a month, I'd export the result of that web query to an Excel file, put in a folder and connect to the monthly extracts using the Folder connector.
Proud to be a Super User!
Power BI itself doesn't retain historical data between refreshes. Each refresh pulls the latest data from the source, which means historical data will be overwritten unless stored elsewhere. If this happens just a month, I'd export the result of that web query to an Excel file, put in a folder and connect to the monthly extracts using the Folder connector.
Proud to be a Super User!
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |