Forum Discussion
PowerQuery/Automate Create Snapshot of DataSet and store within PBI as Calculated Table
the answer is still no. Power BI is not a data storage solution. And it doesn't sound like Fabric is an option for you either.
lbendlin oh gosh 🙂
Cleint does not have storage and i need to find an automated method
The client managed to do the prev vs latest ,ethod by maintaining an csv export of all the data, but now we created an API of latest only
Can PBI automatically store the data externally by creating/created csv and storing snapshots into the file, other than perhaps configuring the csv file, i would like to make the export to csv automated?
or should i rather start of by setting up an excel file that connects to the API and have formulas etc to create the logic of previous but that would also require a manual refresh before importing?
there's no system in between 😞
any ideas please?