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.
Note
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:
Prerequisites: Requires the Vagaro Data Lake integration and a Power BI License.
Important
For larger enterprise locations integrating with Vagaro Data Lake, we recommend purchasing the PPU (Premium Per User) license for Power BI. Some businesses require more memory to run their reports, and the Power BI Pro license has some memory limitations.
You can find and install the Vagaro Power BI app from Power BI's Apps Marketplace.
To install the Vagaro Power BI app:
Please have your Data Location URL and Access Token ready for the steps below.
To sync your data with Power BI:
-
From the Apps page in Power BI, select the Vagaro Template App.
-
Select the Vagaro menu, then select Connect Your Data. You can now import your data from Vagaro.
-
Copy the Data Location URL from Vagaro and paste it into Power BI. Select Next.
-
Copy the Access Token from Vagaro and paste it under SAS token. Select 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.
In addition to the Vagaro Template app, you can create your own reports starting directly from Power BI Desktop. To do this, download the Pbix file from the Vagaro Template app, or you can plug in your Access Token and Data Location URL into PowerBI Desktop.
If you don't want to use Vagaro's Power BI app, you will need to choose the Azure Data Lake Storage Gen2 connection type when creating your own reports. After selecting this connection type, you will then enter your Data Location URL and Access Token.
Comments
0 comments
Please sign in to leave a comment.