Maximize the potential of your business data with the Data Lake integration. Access your data daily, integrate with a data warehouse of your choice, use our Power BI template app with 50+ pre-built reports, and create custom reporting to suit your needs. All of this information will help grow and optimize your business.
With Vagaro's Power BI app, you can view your Power BI reports in just a few steps. You can:
Access 50+ pre-built reports.
Quickly set up in just a few steps.
Create custom reports.
Drill through data points for more granular data.
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.
If you want to access your data with software other than Power BI, your business will need its own storage solution or third-party connector.
A license may be required for any third-party business intelligence tools, connectors, or storage solutions.
Vagaro stores your business's data. With this data, you can generate reports within Vagaro. However, if you want to sync with third-party software, like HubSpot and Tableau, you will need to store that data first. You can pay a company to store your data for you or store it yourself in-house. Vagaro provides you with the location of your data and a key to access it. This allows you to connect using a third-party software or our prebuilt Power BI app.
Vagaro does not currently integrate with other business intelligence software.
For other business intelligence software, you can pull your data into a data storage solution or use a third-party connector, and then visualize your data in the software of your choice. Management, creation, and import of your business's data to your own data storage solution is up to your discretion. Vagaro cannot provide advice or support on setting up reports without PowerBI. For more information, refer to your storage solution provider's documentation.
Any data you retrieve yourself or with Power BI will sync with Vagaro's Data Lake every 24 hours.
Navigate to→ Premium Features → Manage Features.
Scroll down to the Data Lake integration, then click Learn More.
Click Activate Integration.
Wait a few moments for your Data Location URL and Access Token to generate.
Once generated, you can use the Data Location URL and Access Token to gain access to your data. You can input these codes directly into Power BI.
If you are not planning to use our pre-built PowerBi app, then you will need to update the Data Location URL. To do this, replace dfs with blob. For example, change https://storage.dfs.core.windows.net/reports to https://storage.blob.core.windows.net/reports.
You will then need to add the following to the end of your URL: &restype=container&comp=list. For example https://<data location URL with blob change> + "?" + <access token> + "&restype=container&comp=list".
If you want to use Azure SDK to retrieve your data, please see this article from Microsoft.
With the Data Lake feature, you can access your data from multiple locations in one data lake.
When you activate the integration, a pop-up will display where you can select the locations you want to include in the data lake. Please note that you can select just one or all of your locations; there is no limit. Click Activate when you are ready to activate.
Click Manage Locations from the Data Lake integration page to add more locations.