Power BI can use Excel files as a data source and Analytics Edge can automate the refresh of those Excel files. This combination provides a few benefits over the typical cloud-based connector solutions like Windsor.ai or Supermetrics:
- there are no account, query, row or refresh limits because your computer does all the work
- your data doesn’t pass through an intermediate cloud service eliminating privacy or data security concerns
- it can’t get any faster because you get the data straight from the Google API services
- Analytics Edge connectors and macro functions can transform the data before it goes into the Excel file, reducing the data volume and the work required in Power BI
- Analytics Edge is a powerful, no-code (wizard-based) solution designed to get your work done fast
- Analytics Edge can also write to CSV/TSV files, so you don’t need to worry about the million-row limit or large workbook instability.
Note that the refresh of the Excel file must happen from your computer. With the Windows version of the products, you can schedule these refreshes.
You can try it out, fully functional and free for 30 days, no credit card required. Analytics Edge is available as an Add-in for Microsoft Excel (on Windows) or as a Desktop App (Windows and MacOS). Download now