Data Storage advice

Hi Anonymous ,

Could you please try to use R on Power BI Desktop. An R transformation could snap the data and save as a file, you can then load a folder of files and use the filename to to ensure you know when it was snapped.

You can use R in Power BI Desktop's Power Query Editor to:

• Prepare data models.

• Create reports.

• Do data cleansing, advanced data shaping, and dataset analytics, which include missing data completion, predictions, clustering, and more.

Limitations:

• All R data source settings must be set to Public.

• To schedule refresh of your R visuals or dataset, enable scheduled refresh and install an on-premises data gateway (personal mode) on the computer containing the workbook and R.

More details: Use R in Power Query Editor 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.