Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Please visit the following link for details: https://powerbi.microsoft.com/en-us/
This integration is only available for Software Assurance (SA) Subscribers. Please also note it is only supported by the latest versions of D-Tools System Integrator. While the connection to our API is included in your SA subscription, Power BI offers different pricing levels. The free version of Power BI or Excel may not work: https://powerbi.microsoft.com/en-us/pricing/
Please request access to the integration by sending an email to api@d-toolshelp.com prior to perform the setup. D-Tools will enable access to your specific account within 48 hours.
Please take a few minutes and familiarize yourself with how our API works. The following article provides an overview of the functionality and technical aspects of our API: https://support.d-tools.com/Integrations_Support/Administrator_Guide/Cloud_API_Technical_Aspects
In order to use this integration, you must first set it up. This is a one-time setup. You will need an active Power BI account and have requested the API key to us. The below setup will walk you through the process of Setting up the integration with Power BI for access to D-Tools Projects. The setup for the additional API services is similar, and can be appended to your project setup.
1. In SI, go to Start->Control Panel, then open "Manage Integrations".
Important note: If this feature is not available, please send an email to api@d-toolshelp.com requesting access to this particular integration, and we will enable it for you. Please note you must be on the latest version of D-Tools and subscribing to Software Assurance (SA) to access this feature.
2. Select Power BI, then click the "View API Key" link
3. Click the [Copy] button to copy your API Key and then close these windows.
4. Export a few projects to Power BI - From the Project Explorer, please select the Project (or Projects) you wish to export, Check each project out (click on "Check out"), and then click the Integrations tab, then on the [Export] button:
-
5. Open Power BI -> Get Data -> Web
6. Click on Advance
Enter the URL part, in this case, https://api.d-tools.com/SI/Subscribe/Projects
Here is more info about this service endpoint: https://api.d-tools.com/SI/doc/Api/GET-Subscribe-Projects_clients[0]_clients[1]_progresses[0]_progresses[1]_includeImported_searchText_pageNumber_pageSize_projectNumber
Enter the X-DTSI-ApiKey followed by your API key
This is how it should look like:
7. You should now see a list of all projects published to the API, and that are being consumed by Power BI:
8. We now recommend adding the following steps:
9. On the "Add custom" step, please create a new Query with the following code:
(ID as text) =>
let
Source = Json.Document(Web.Contents("https://api.d-tools.com/SI/Subscribe/Projects?id="&ID, [Headers=[#"X-DTSI-ApiKey"="API KEY"]]))
in
Source
This is how it should look like:
10. At this point, you should have all your project data loaded on the query. You can further expand the items list using the same method described in step 9.
11. Close and Apply. You can now build reports and dashboards.
If you need help or have any questions, our Professional Service team can be consulted and we can help. Please send an email to api@d-toolshelp.com requesting assistance.