Power BI Desktop is an application that allows you to connect to, transform, and visualize the data. Using Power BI Desktop, you can connect with the SummitAI data source, visualize the data, and create the required reports.

You can leverage the following benefits by using Power BI with the SummitAI database:

• Visualize the Reports and Dashboards by creating them using the information available in the SummitAI data.

Follow the below prerequisites:

1. Download the SummitAI.mez file from the below path:
   https://summitbuild.blob.core.windows.net/common/summit-powerbi-dataconnector.zip

2. Copy and paste the SummitAI.mez in the Documents folder of the local path as follows:
   C:\Users\Username\Documents\Power BI Desktop\Custom Connectors

3. On the Power BI Desktop, click File > Options and Settings > Options > Under GLOBAL sections, click Security > Under Data Extensions, select Allow any extension to load without validation or warning > Click OK.
   
   

   
   
   

To connect with SummitAI:

1. On the Power BI Desktop home page, click Get data. The Get Data pop-up page is displayed.
   
   

   
   
   
   

2. Search and select the Summit connector and then click Connect.
   
   

   
   
   
   

3. On the From Summit.Contents pop-up page, specify the Summit API URL and Summit API Key to complete the authentication process.
   
   

   
   
   

4. Click OK.

5. Based on the Summit data collector, the Navigator page displays the list of all DN tables, and two functions named Get Data and Get Schema.
   
   

   
   
   
   
   
   

6. Select the function Get Data and specify all the required fields as shown in the below screenshot:
   
   

7. Select the function Get schema and specify all the required fields as shown in the below screenshot:
   
   

8. Select the table to preview the columns of the selected table.
   
   
   

   Open

   

   
   
   
   

9. Click Load to load the data.

10. Select the view from the VISUALIZATIONS and select the required columns from the DN table.
    
    
    

    Open

    

Instead of Summit data connector, you can also connect with the Power Bi by writing a Query in Power BI Query language.

To Write and Execute Power BI Query:

1. On the Power BI Desktop home page, click Get data. The Get Data pop-up page is displayed.

2. Select the Blank Query/Web and then click Connect.

3. Under the mini toolbar, select Advanced Editor, and then provide the Query to get the data.

   Sample Query 1

   let     datasource="SR_RPT_DN_ServiceTicketMaster",     apikey="XXXXXXXXXXXXXXXXXXX",   baseurl="https:// <SummitAI Reporting API URL>/API/getdata",     url=""&baseurl&"?datasource="&datasource&"&apikey="&apikey&"",     source = Json.Document(Web.Contents(url)),     results = Table.FromRecords(source[results]) in    results

   Sample Query 2

    let    url = "https:// <SummitAI Reporting API URL>/API/getdata",    body = "{             ""DataSource"": ""IM_RPT_DN_TicketMaster"",             ""Columns"": ""[ticket id],[Ticket No],[Registered Time],status,[Sup Function Name],[Workgroup Name]"",             ""Filters"": ""status in ('new','closed')"",             ""PageIndex"": 1,             ""PageSize"": ""10000"",             ""SortColumn"": ""[ticket id]"",             ""SortOrder"": ""ASC"",             ""APIKey"":""XXXXXXXXXXXXXXXXXXXXXXXXXXX"",             ""RawSQL"":""""            }",    source  =    Json.Document(        Web.Contents(            url,            [                Headers = [#"Content-Type"="application/json"],                Content=Text.ToBinary(body)            ]        )    ),     results = Table.FromRecords(source[results]) in     results

4. Create the data and then click Apply on the mini toolbar.