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.
Hi,
I followed this documentation: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh to create two incremental refresh parameters (RangeStart and RangeEnd, Type as Date).
Then I applied the custom filter using these parameters in my data table. However, after close and apply query editor, the incremental refresh setting is still not giving me option to turn it on.
Can someone please help with this issue? Not sure if incremental refresh only applies to relational database? My raw data source is a sharepoint folder with some excel spreadsheets.
Appreciate the help in advance!
Thanks,
Dennis
Solved! Go to Solution.
@Anonymous - Make sure that your parameters are of type datetime. Your image shows that they are date.
@Anonymous - Make sure that your parameters are of type datetime. Your image shows that they are date.
Thanks @Greg_Deckler! I changed the data type to date/time and it works! I thought date data type would also work.
@Anonymous , Check if datetime, or some other data type for the columns in the table. This issue is usually of a data type mismatch.
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.
User | Count |
---|---|
111 | |
97 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |