Power BI is data visualization software from Microsoft which allows you to create customized dashboards and reports. This integration allows you to create a live data link to WeTrack which can be updated at regularly scheduled intervals.
Setting up a Data Feed
WeTrack allows you to set up multiple data feeds to Power BI. Each data feed can be custom filtered to provide a discrete data set to the end user. Data feeds can be established for:
-
Incidents and Logs from the Control Module
-
Projects and Tasks/Milestones from the Planning Module
-
Run Sheet Data from the Run Sheets Module
-
Jobs Checklist Items from the Control Module
-
Indicator Updates and their associated attributes from the Sustainability Module
In the settings area go to Account & Configuration -> Power BI Integrations, then click "Add Power BI Feed"
This will open a modal which will allow you to select the data you want to include in your new feed. The filter types available will depend on the type of data to be included.
Setup steps:
-
Give the feed a name
-
In the second row, select the type of data to include in the feed (Projects, Tasks, Incidents (including logs), or Run Sheets. You can only include one type of data in a single feed. To integrate multiple data types you will need to create multiple feeds.
-
Select any filters you want to use for your data feed. If you leave a filter empty the data feed will be unfiltered and will include all items of that type
-
Click Save when done. Don't worry, you can always come back and update these settings later.
Linking WeTrack to Power BI
Once you have set up the data feed you can complete the connection between WeTrack and Power BI.
If not open already, click on "Show Credentials" for the feed which you have created. This will open the screen shown below.
Next, open Power BI, then click on "Get Data" and then "Web"
-
Click on the Advanced tab
From here we will copy and paste the data in the WeTrack Power BI Integration Details Page into Power BI
-
Copy/paste the "URL" into the "URL Parts" field
-
Copy/paste the "Authorization" key into the key value for the header
-
Copy/paste the authorization header value into the value field
-
Click "Add Header"
-
Click OK
-
After clicking OK, the system may pop up a window titled "Access Web Content" saying "Use anonymous access for this Web content."
-
Click "Connect" on this screen.
-
The system will show a "Connecting" screen. This may take 10-20 seconds to establish. You can just wait here and let the system work
When this closes the link between WeTrack and Power BI has been established. You can now create data visualizations within Power BI from your WeTrack data.
Comments
0 comments
Article is closed for comments.