Intro
In our previous post we discussed the difference between the AthenaHealth data delivery options. In this post we are going to cover how to connect Power BI to Data View. This post assumes you have already installed Power BI on your computer. If you have not you can download it here.
Gather Information
To get started you will need to find out what your SnowFlake URL is. In Athena if you open Practice Manager Admin there is an option for Data View Settings. To access this your Athena account will need to be in the Data View Admin role. Once on the Data View Setting page you should see your URL at the top of the page. Copy that URL somewhere so we can use it later.
Connect
Open up Power BI and click Get Data then More….
On the next screen type snow into the search box, select Snowflake, and click Connect.
Now you will need that URL we copied from Athena earlier. Paste in everything from your URL after the https:// into the Server field. In the Warehouse field enter AH_WAREHOUSE, and in the Database field enter ATHENAHEALTH. Click OK to connect.
Once connected you will see the ATHENAHEALTH database, click the carrot to expand it. Underneath you will see all of the schemas. Expanding any one of those will expose the tables available. From there you can select which tables you want to bring into your report\data model.
October 31, 2023 at 7:06 pm
For a company seeking financial analysis of their Athena Data for strategic planning, what is a comparison of using Athena’s SalesForce vs Athena’s DataView and MS BI?
thanks
November 6, 2023 at 10:05 pm
I have never used Athena’s SalesForce so I can’t give you any advice on what that dataset offers compared to DataView. If I were an Athena client and wanted to compare the two offerings, I would request a trial of each and dump the dataset to an environment I control. I say moving it to a new environment because trials are short and unknowns always come up. Test out the use cases you have with the datasets and make your decision from there.
Having never heard of the SalesForce offering I am wondering why they have a separate offering from DataView. I would think the two datasets have something unique to offer.