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,
I am using multiple tables from multiple sources.I have a requirement where we need to take a snapshot of data in beginning of quarter and maintain it through out the quarter without refreshing it in only one single table. I was able to achieve so by loading the table in power bi desktop and disabling the refresh. But when i publish it , it refreshes all the data including the snapshot table as well. I need to take snapshot of current quarter only so i am unable to do it in incremental refresh as it stores data for previous quarters(I might be wrong here as i am learning it). Do you guys can suggest any idea how to make a table fixed for a quarter while other tables refresh daily?
Thanks
You might need to have another ETL (SSIS) layer which can fulfill the requirement and that can refresh the quaterly static table.
Without the ETL I don't think it is possible just with the PowerBI alone.
Cheers,
Hari T
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
5 | |
4 | |
1 | |
1 | |
1 |
User | Count |
---|---|
8 | |
5 | |
4 | |
4 | |
2 |