We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.
At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.
You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh
We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!
Yes it is. But you have to use advanced editor. The way I did this was to first load data from an input file into a table. Then I created a second query that loads data from that newly created table. Then I used advanced editor to change the first query in start with the steps from the first query and append the results. And you can avoid duplicate rows by creating a new column with some sort of compound key from your various columns (and later remove this column if you want, once dups are removed).
Note also, it would be nice to remember different sort options at different levels of drill down.
Here is a concrete example: At higher levels you are aggregating items and visualizations like bars or pies make sense. If you drill down to individual items, a table makes more sense.Anonymous supported this idea ·