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.
I have data stored in table storage and data set is huge which is casuing the data load failure
Can we load limited data in during refresh like only the last 7 days of data or current / previous date data ..
There is a date field in the table
@Anonymous - Yes, you can use Incremental Refresh.
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Thanks for the quick responce, I tried usign Incremental refresh however not sure how I can add dynamic filter on date column like pick only dynamic current or last date data only. for every day refresh
@Anonymous Look at the Refresh ranges part of the document link I sent. If I understand what you are asking about.
@Greg_Deckler I tried to lookup this option However unable to find this . Is it in PowerBI service once the parameters are added and is Table Storage connector an approved one .
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.