Forum Discussion
Storing and using information from a dynamic data source using PBI desktop.
Hello, This is something that I've worked in for a couple of months, and have been successfully using it for 3 months, and now would like to share with the community. If you want to know where th...
Hi Salvador...this is a great idea but the data i have is over 10000 rows and the file gets updated everyday with new info and the old file gets deleted..I'm thinking the size of the file would be a bit impracticle if i keep a record of all the data..all i need is the summary of various status for the previous day as a count that then goes into my final table is it possible to achieve this using this technique?
Hello,
If you create the a table in your model with the summarized info that you need, you could use this method. You can also use dax studio to export info to csv, but havent found a way to automatize it.
