Hello
do we have option for incremental datare fresh by doing start & end date parameters using Power BI Pro license..? I did lookup some article and followed steps but much couldnt help. Any help would be aapreciated.
1) I imported fact table which has changedate(load date) column as flag indicator for timestamp.
2) Date dim table with start of year & current date column for start & end date Params.
3) i applied filter on fact table within M query by doing parameter range.
4) Published to Personal workspace and i dont see any options for incremental refresh. Seems i missing steps somewhere, can some one navigate how to apply
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
You must have premium, but there is new premium per user coming soon: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-per-user-faq
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
65 | |
51 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |