Direct Integration from Power BI

It is possible to import an entire table from ATTOM Cloud into Power BI as well as to import selected rows/columns from one or more tables using a SQL Query.

Creating a SQL Database Connection

To use ATTOM Cloud data from within Power BI we must create a SQL Database connection using the information provided in Direct Integration..

Select File :: Get data :: SQL Server database from the menu and then click on Connect

Import an Entire ATTOM Cloud Table

Note: Details about the ATTOM Cloud database can be found under DIrect Integration. 

Create Connection to Database

1. Enter the hostname as Server
2. Provide the Database.
3. Select OK

Provide Credentials

1. Select Database (credentials)
2. Enter User name (from Direct Integration)
3. Provide the current password used to access ATTOM Cloud

Select Table/View

1. Selected the table (or tables) to be imported. A preview of the (last) selected table will be displayed to the right.
2. Select Load if you wish to import the table(s) as-is; or
3. Select Transform Data if you would like to transform the data in any way

Note: The database schema may be presented differently from the way it is displayed inside ATTOM Cloud. The tables/views may get listed under a single schema called ADW.

Import Data Using a SQL Query

To import a subset of data (rows or columns) from an ATTOM Cloud table/view or to combine data from two or more tables, use a SQL Query.

Note: It is usually a good idea to test the SQL query against the data first using ATTONM CLiud's SQL Editor or your own SQL Editor.

1. Enter the hostname as Server
2. Provide the Database.
3. Expand Advanced options
4. Paste the SQL code into the SQL statement
5. Select OK
6. The results from the query will be displayed (not if you have not already provided credentials to access the database you may be requested to do so). 
7. Select Load to import that data as-is or Transform Data if you wish to make additional changes to the data.

Refreshing the Data

It is possible at any time to refresh the data loaded from ATTOM Cloud

1. Select the Table, View, or Query from the Data view
2. Under More Options select Refresh data