Idea - Planned Send SQL Query Results to OneDrive as CSV to be consumed by Power BI

This idea is to make it as easy as possible for you to consume Acumatica data in Microsoft Power BI.

This idea is the use case that initially got me thinking of creating AugSQL in the first place so this idea is very near and dear to me.

This idea would depend on the completion of these ideas:

https://www.augforums.com/forums/augsql/saved-sql-queries

https://www.augforums.com/forums/augsql/scheduled-queries

There are already products out there like DataSelf ETL+ (click here) that allow you to schedule the refresh of your Acumatica data. DataSelf ETL+ pulls the Acumatica data over OData and puts it into a SQL Database. It only refreshes the data that changed since the last refresh since OData is really slow and refreshing all of the data could take forever. That's all really cool, but it requires you to have a SQL Database running somewhere that acts as your Data Warehouse.

Instead of pulling Acumatica data over OData into a SQL Database, what if we could push Acumatica data into a CSV file in OneDrive? Most people already have OneDrive which includes 1TB of storage if you're on Office 365 so you have plenty of storage space. Actually, interestingly enough, Microsoft recently launched Microsoft Fabric and they created a new concept called OneLake which is a centralized way to store data. This idea would be using OneDrive as a Data Warehouse similar to the OneLake idea that Microsoft is promoting.

If we could get the Acumatica data into OneDrive as a CSV, then Power BI can easily consume the CSV data. Actually, I did a test and it seems that Power BI can consume data stored in a CSV file in OneDrive twice as fast as it can consume data stored in a SQL Database. Here is my test:

So, what if we could piggy-back on the Passing Parameters to SQL Queries idea (click here) idea and have a URL parameter option like CSVtoOneDrive which could be called like this:

https://mycompany.acumatica.com/Main?CompanyID=SalesDemo&ScreenId=QQ900003&Action=CSVtoOneDrive&MyParam1=MyValue1&MyParam2=MyValue2

Calling that URL would automatically send the results of the SQL Query to OneDrive as a CSV.

Bonus points if the CSV could be sent to OneDrive as a zipped file since CSV files compress really well when zipped and Power BI can read a zipped CSV file.