With Vagaro's Data Lake feature, you can retrieve your data—like appointment reports, payroll, and gross sales data—to Power BI. You can download the Vagaro Power BI app to create a direct connection between your data and Power BI without the need for a data storage solution.
The steps below will show you how to install a Power BI app on the Web version of Power BI. See the following articles for more information:
Vagaro's Data Lake Feature: $40 a month. Extra $10 a month for each additional location (within Vagaro's Multi-Location Feature).
Work or School Power BI Account: If you would like to use Vagaro's Power BI app, you will need a Power BI license.
You can find and install the Vagaro Power BI app from Power BI's Apps Marketplace.
Please have your Data Location URL and Access Token ready for the steps below.
From the Apps page in Power BI, click the Vagaro Template App.
Click the Vagaro menu, then click Connect Your Data. You can now import your data from Vagaro.
Copy the Data Location URL from Vagaro and paste it into Power BI. Click Next.
Copy the Access Token from Vagaro and paste it under SAS token. Click Sign in and connect.
Power BI may take some time to refresh. Once you've connected to Vagaro, you now have access to 50+ pre-built reports.
Keep in mind that once connected, Power BI will sync with Vagaro's data lake every 24 hours.