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.
If I'm not mistaken this is not yet available, with that...
- does it mean that I have to maintain all my historical files locally(or wherever they are currently located)?
- does that mean that if I do a data refresh in PowerBI Service it will go through record 1 to record N?
Also, I would want to ask... since Excel can only keep up to a million lines how do I extend it? Workbook1, Workbook 2, I know PBI can merge this
- do I have to maintain a naming convention so that upload is done chronologically?
Solved! Go to Solution.
There are a few approaches. Read my blog series starting here. http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/
I believe you can load a table and then disable refresh. I have never tried it but I assume you should be able to load a history file (say years 2014 -2016) and not refresh them on reload - you would need to test it
Upload order is not important.
There are a few approaches. Read my blog series starting here. http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/
I believe you can load a table and then disable refresh. I have never tried it but I assume you should be able to load a history file (say years 2014 -2016) and not refresh them on reload - you would need to test it
Upload order is not important.
Thanks again @MattAllington, your recommendations are enough to flag this as solved! I'll take your word for it... but I will test and get back to this post what I have discovered.
Thanks for the link as well, I will read through it (learn from it).
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |