Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
3 |