I think the real usage of it, is to "partially" refresh data. Here is an example. I have 5 years of big data and when I refresh, the only thing matter is current year. Ican set up 4 previous years as an import, and 1 current year as the other import, after that , I appended 2 as new table. Then I set 4 years one as "include in report refresh = false" + "enable load"=False and the 1 current year as "include in report refresh = true" + "enable load"=False. After all, data module will only show the appened 2 dataset as one, and when I refresh the "appended" one, only the current year data got partially refreshed. It really saves time when I have 200 millions rows.
@BIConsultingPro
Жыл бұрын
For your case, rather than this you can use incremental refresh. That would be the best option, I believe. However, I really appreciate your time, and your thoughts over it.
@mnesevati
3 жыл бұрын
You are the best .....and deserve 100k subscription &likes
@shwetadalal1549
3 жыл бұрын
Thanks for wonderful explanation!
@anuragbawankar685
3 жыл бұрын
Thanks!
@bhaskarchintu1986
2 жыл бұрын
Hello, how to create a dynamic model for changing columns in the matrix table. We will take Sales data where I want to see the Net sales based on MTD, QTD, YTD with changing columns with Invoice number, customer name, customer number, Sales Person, Sales ID.
@ravireddy270
2 жыл бұрын
Love your explanation
@BIConsultingPro
2 жыл бұрын
Glad it was helpful!
@sushmasonker1990
3 жыл бұрын
i have two table,I want to add a row in a coloum from another table and also want to add values for that row in other column of where I add that row,how to do?
@BIConsultingPro
3 жыл бұрын
Is your Data coming from a data source or you have manually entered it in Power BI? If it's coming from a source, then I suggest you add it at the source only! Otherwise, if you want to do it in Power BI only, then you have to duplicate the first table and remove unnecessary columns from it. After that merge with your another table.
@sravankumar1767
3 жыл бұрын
Nice explanation.. what's your name, from which country bro
@BIConsultingPro
3 жыл бұрын
Thanks Sravan for your humble words. My name is Ajay and I born and brought up in India. However, I live and work in Singapore
@PedroCabraldaCamara
3 жыл бұрын
Very good!!! What if you merge this finance table with a country table with 2 columns, country name and country code. I just add the country code to finance table. Can i untick the enable load on this dim table?
@BIConsultingPro
3 жыл бұрын
Why don't you give it a try? If you didn't get it, let me know, I'll help you :)
Пікірлер: 14