{"id":29509,"date":"2024-11-26T15:07:50","date_gmt":"2024-11-26T15:07:50","guid":{"rendered":"https:\/\/help.desk365.io\/en\/?post_type=docs&p=29509"},"modified":"2026-03-18T18:30:27","modified_gmt":"2026-03-18T18:30:27","slug":"articles-integrate-desk365-with-power-bi","status":"publish","type":"docs","link":"https:\/\/help.desk365.io\/en\/articles\/integrate-desk365-with-power-bi\/","title":{"rendered":"Integrate Desk365 with Power BI"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t
\n Available with:<\/span>\n \n \n \n <\/circle>\n <\/path>\n <\/svg>\n Standard<\/span>\n <\/span>\n \n |<\/span>\n \n \n \n <\/circle>\n <\/path>\n <\/svg>\n Plus<\/span>\n <\/span>\n \n |<\/span>\n \n \n \n <\/circle>\n <\/path>\n <\/svg>\n Premium<\/span>\n <\/span>\n<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Integrating\u00a0<\/span>Desk365<\/span><\/a>\u00a0with\u00a0<\/span>Power BI<\/span><\/a>\u00a0is a straightforward process that involves a few simple steps. You need to import the data from Desk365 into Power BI with the help of the <\/span>Desk365 <\/span>API<\/span><\/a> and then you can transform it into customized, impactful reports using Power Query with pagination, which enables data cleansing, shaping, and combining data from multiple sources. And then you can filter the tickets within the report in Power BI.<\/span>\u00a0<\/span><\/p>

By the end of this help center article, you\u2019ll be able to create interactive reports and dashboards that provide valuable insights into your customer support operations.<\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Establish connection with Desk365's API <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

To initiate the integration of Desk365 with Power BI, you have to establish a connection with Desk365\u2019s API from Power BI. To do that navigate to your Power BI tool and perform the following actions.<\/span>\u00a0<\/span><\/p>

  1. Select\u00a0Web\u00a0from common data sources under\u00a0Get data.<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
    \n\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\"import-data-from-web-page-desk365\"\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
    \n\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t

    2. Click on\u00a0Advanced\u00a0and fill in the details as mentioned below.<\/span><\/span>\u00a0<\/span><\/p>

    Enter the <\/span>below link<\/span> in URL parts.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\n\t\t\t\t\thttps:\/\/<<yoursubdomain>>.desk365.io\/apis\/v3\/tickets<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-61f96a9 e-flex e-con-boxed e-con e-parent\" data-id=\"61f96a9\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-405d121 elementor-widget elementor-widget-text-editor\" data-id=\"405d121\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"NormalTextRun SCXW105676620 BCX0\">Under HTTP request header parameters, type the value as \u2018<\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW105676620 BCX0\">Authorization\u2018 and<\/span><span class=\"NormalTextRun SCXW105676620 BCX0\"> set the value to \u2018&lt;&lt;YOUR-DESK365\u2019S-API-KEY&gt;<\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW105676620 BCX0\">&gt;\u2018\u00a0as<\/span><span class=\"NormalTextRun SCXW105676620 BCX0\"> shown below\u00a0and click on \u2018Ok\u2019.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1282db0 e-flex e-con-boxed e-con e-parent\" data-id=\"1282db0\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8ee2f89 elementor-widget elementor-widget-image\" data-id=\"8ee2f89\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"607\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/enter-url-parts-desk365-power-bi-1024x607.webp\" class=\"attachment-large size-large wp-image-29558\" alt=\"enter-url-parts-desk365-power-bi\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/enter-url-parts-desk365-power-bi-1024x607.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/enter-url-parts-desk365-power-bi-300x178.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/enter-url-parts-desk365-power-bi-768x456.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/enter-url-parts-desk365-power-bi.webp 1310w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-10f93fa e-flex e-con-boxed e-con e-parent\" data-id=\"10f93fa\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e53a612 elementor-widget elementor-widget-text-editor\" data-id=\"e53a612\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"NormalTextRun SCXW103622045 BCX0\">3. As the next step, select the same link mentioned earlier in the \u2018Access Web content\u2019 pop-up and click \u2018Connect\u2019<\/span><span class=\"NormalTextRun SCXW103622045 BCX0\">.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-33e40cb e-flex e-con-boxed e-con e-parent\" data-id=\"33e40cb\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-70582b9 elementor-widget elementor-widget-image\" data-id=\"70582b9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"399\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/integrate-desk365-with-power-bi-1-1024x399.webp\" class=\"attachment-large size-large wp-image-29560\" alt=\"integrate-desk365-with-power-bi\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/integrate-desk365-with-power-bi-1-1024x399.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/integrate-desk365-with-power-bi-1-300x117.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/integrate-desk365-with-power-bi-1-768x299.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/integrate-desk365-with-power-bi-1.webp 1241w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5fa3eca e-flex e-con-boxed e-con e-parent\" data-id=\"5fa3eca\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c547642 elementor-widget elementor-widget-text-editor\" data-id=\"c547642\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW206832392 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW206832392 BCX0\">Your Power BI is now successfully connected to Desk365\u2019s API.<\/span><\/span><span class=\"EOP SCXW206832392 BCX0\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-af171a7 elementor-widget elementor-widget-heading\" data-id=\"af171a7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Create a function to fetch the list of tickets from the Desk365 API<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-730e12f elementor-widget elementor-widget-text-editor\" data-id=\"730e12f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The second step to integrate Desk365 with Power BI is to create a function. This function facilitates the retrieval of tickets and their corresponding details from Desk365.<\/p><p>Follow the below steps:<\/p><ol><li>Navigate to your Power BI platform.<\/li><li>Right click and select new query &gt; blank query.<\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8abd2b elementor-widget elementor-widget-image\" data-id=\"f8abd2b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"556\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/creating-blank-query-in-power-bi-1024x556.webp\" class=\"attachment-large size-large wp-image-31136\" alt=\"creating-blank-query-in-power-bi\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/creating-blank-query-in-power-bi-1024x556.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/creating-blank-query-in-power-bi-300x163.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/creating-blank-query-in-power-bi-768x417.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/creating-blank-query-in-power-bi.webp 1135w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9fffcac elementor-widget elementor-widget-text-editor\" data-id=\"9fffcac\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>3. Rename the query to GetAllTickets<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd4ba19 elementor-widget elementor-widget-image\" data-id=\"bd4ba19\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/renaming-query-to-get-all-tickets-1024x256.png\" class=\"attachment-large size-large wp-image-31137\" alt=\"renaming-query-to-get-all-tickets\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/renaming-query-to-get-all-tickets-1024x256.png 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/renaming-query-to-get-all-tickets-300x75.png 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/renaming-query-to-get-all-tickets-768x192.png 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/renaming-query-to-get-all-tickets.png 1481w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97392cc elementor-widget elementor-widget-text-editor\" data-id=\"97392cc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><br \/>4. Copy and paste the provided function code into the Advanced Editor and click Done<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5659a3c elementor-widget elementor-widget-code-highlight\" data-id=\"5659a3c\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>let\r\n    \/\/ Base URL and API Key for the API requests\r\n    BaseUrl = \"https:\/\/yoursubdomain.desk365.io\/apis\/v3\/\",\r\n    ApiKey = \"<<YOUR-DESK365-API-KEY>>\",\r\n    \/\/ Number of tickets per page (possible values: 30, 50, 100)\r\n    TicketCount = 30,\r\n\r\n    \/\/ Query parameters for fetching tickets, including custom fields, survey details, and activity since a specific time\r\n    QueryParams = [\r\n        ticket_count = Text.From(TicketCount),     \/\/ Include tickets per page\r\n        include_description = \"0\",                 \/\/ Include description in the response\r\n        include_custom_fields = \"0\",               \/\/ Include custom fields in the response\r\n        include_survey_details = \"0\",              \/\/ Include survey details in the response\r\n        order_by = \"created_time\",                 \/\/ Sort tickets by \"created_time\" or \"updated_time\"\r\n        order_type = \"desc\",                       \/\/ Specify the sorting order \"asc\" (ascending) or \"desc\" (descending)\r\n        updated_since = \"2024-11-01 08:48:06\"      \/\/ Filter tickets with activity since the specified timestamp\r\n    ],\r\n\r\n    \/\/ Function to Fetch a Single Page of Data\r\n    FetchPage = (offset as number) =>\r\n        try\r\n            Json.Document(Web.Contents(\r\n                BaseUrl,\r\n                [\r\n                    RelativePath = \"tickets\",\r\n                    Query = Record.Combine({[offset = Text.From(offset)] & QueryParams}), \/\/ Combine base query and custom query params\r\n                    Headers = [Authorization = ApiKey]\r\n                ]\r\n            ))\r\n        otherwise [tickets = {}, next_page = null, count = 0], \/\/ Default response in case of error\r\n\r\n    \/\/ Fetch initial data to get the total count\r\n    Source = FetchPage(0),\r\n    TotalTickets = if Source = null or not Record.HasFields(Source, \"count\") then 0 else Source[#\"count\"],\r\n\r\n    \/\/ Calculate the number of pages needed\r\n    PageCount = Number.RoundUp(TotalTickets \/ TicketCount),\r\n\r\n   \/\/ Generate a list of offsets for each page, using PageCount to limit the number of iterations\r\n    PagesData = List.Generate(\r\n        \/\/ Start with the first page's response\r\n        () => [Page = 0, Response = Source], \/\/ Fetch the first page only once here\r\n        each [Page] < PageCount, \/\/ Limit the iteration to PageCount\r\n        each [\r\n            Page = [Page] + 1,                       \/\/ Increment the page counter by 1\r\n            Response = Function.InvokeAfter(() => FetchPage(Page * TicketCount),#duration(0,0,0,1)) \/\/ Fetch the next page using the updated offset (Page * TicketCount)\r\n        ],\r\n        each [\r\n            Count = [Response][count],    \/\/ Extract the total count of tickets\r\n            Tickets = [Response][tickets] \/\/ Extract the list of tickets from the response\r\n        ]\r\n    )\r\nin\r\n   PagesData <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-87481ae e-flex e-con-boxed e-con e-parent\" data-id=\"87481ae\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5f8b9f elementor-widget elementor-widget-text-editor\" data-id=\"e5f8b9f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>5. Now, create another new query (e.g., name it Tickets).<br \/>6. Open the Advanced Editor for this query and paste the second block of code provided.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a6a9bca elementor-widget elementor-widget-code-highlight\" data-id=\"a6a9bca\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>let\n    \/\/ Call the GetAllTickets function\n    PagesData = GetAllTickets,\n \n    \/\/ Flatten the list of tickets and include the count\n    FlattenedTicketsWithCount = List.Transform(PagesData, each List.Transform([Tickets], (ticket) => Record.AddField(ticket, \"count\", [Count]))),\n \n    \/\/ Combine all tickets from each page into one list\n    CombinedTickets = List.Combine(FlattenedTicketsWithCount),\n \n    \/\/ Convert the list of records into a table\n    TicketsTable = Table.FromRecords(CombinedTickets),\n \n    \/\/ Select specific columns from the tickets table that are needed\n    SelectedColumnsTable  = Table.SelectColumns (\n        TicketsTable,\n        {\n            \"count\",\n            \"ticket_number\",\n            \"contact_email\",\n            \"subject\",\n            \"description\",\n            \"description_text\",\n            \"status\",\n            \"priority\",\n            \"type\",\n            \"source\",\n            \"assigned_to\",\n            \"company_name\",\n            \"sla\",\n            \"group\",\n            \"category\",\n            \"subcategory\",\n            \"created_on\",\n            \"updated_on\",\n            \"resolved_on\",\n            \"closed_on\",\n            \"due_date\",\n            \"first_response_time\",\n            \"first_assigned_time\",\n            \"first_assigned_duration\",\n            \"resolved_duration\",\n            \"first_replied_duration\",\n            \"closed_duration\",\n            \"custom_fields\",\n            \"survey_rating\"\n        },\n        MissingField.Ignore\n    ),\n \n   \/\/ Source mapping table\n    SourceMappingTable = #table({\"Key\", \"Value\"}, {\n        {1, \"Email\"},\n        {5, \"Microsoft Teams\"},\n        {6, \"Support Portal\"},\n        {7, \"Phone or Other\"},\n        {12, \"Web Form\"},\n        {13, \"Web Widget\"}\n    }),\n \n    \/\/ Check if the \"source\" column exists\n    SourceExists = List.Contains(Table.ColumnNames(SelectedColumnsTable), \"source\"),\n \n    \/\/ Join SourceMappingTable to SelectedColumnsTable on source\n    MergedSource = if SourceExists then\n        Table.NestedJoin(\n            SelectedColumnsTable, \"source\",\n            SourceMappingTable, \"Key\",\n            \"SourceMapping\", JoinKind.LeftOuter\n        )\n    else\n        SelectedColumnsTable,\n    \/\/ Expand the mapped value\n    ExpandedSource = if SourceExists then\n        Table.ExpandTableColumn(MergedSource, \"SourceMapping\", {\"Value\"}, {\"source_text\"})\n    else\n        MergedSource,\n \n    \/\/ Priority mapping table\n    PriorityMappingTable = #table({\"Key\", \"Value\"}, {\n        {1, \"Low\"},\n        {5, \"Medium\"},\n        {10, \"High\"},\n        {20, \"Urgent\"}\n    }),\n \n    \/\/ Check if the \"priority\" column exists\n    PriorityExists = List.Contains(Table.ColumnNames(ExpandedSource), \"priority\"),\n \n    \/\/ Join PriorityMappingTable to ExpandedSource on priority\n    MergedPriority = if PriorityExists then\n        Table.NestedJoin(\n            ExpandedSource, \"priority\",\n            PriorityMappingTable, \"Key\",\n            \"PriorityMapping\", JoinKind.LeftOuter\n        )\n    else \n        ExpandedSource,\n \n    \/\/ Expand the mapped value\n    ExpandedPriority = if PriorityExists then\n        Table.ExpandTableColumn(MergedPriority, \"PriorityMapping\", {\"Value\"}, {\"priority_text\"})\n    else\n        MergedPriority,\n        \n    \/\/ Rename the selected columns for clarity\n    RenamedColumnsTable = Table.RenameColumns (\n        ExpandedPriority,\n        {\n            {\"ticket_number\", \"Ticket Number\"},\n            {\"contact_email\", \"Contact Email\"},\n            {\"subject\", \"Subject\"},\n            {\"description\", \"Description\"},\n            {\"description_text\", \"Description Text\"},\n            {\"status\", \"Status\"},\n            {\"priority\", \"Priority\"},\n            {\"type\", \"Type\"},\n            {\"source\", \"Source\"},\n            {\"assigned_to\", \"Assigned To\"},\n            {\"company_name\", \"Company Name\"},\n            {\"sla\", \"SLA\"},\n            {\"group\", \"Group\"},\n            {\"category\", \"Category\"},\n            {\"subcategory\", \"Subcategory\"},\n            {\"created_on\", \"Created On\"},\n            {\"updated_on\", \"Updated On\"},\n            {\"resolved_on\", \"Resolved On\"},\n            {\"closed_on\", \"Closed On\"},\n            {\"due_date\", \"Due Date\"},\n            {\"first_response_time\", \"First Response Time\"},\n            {\"first_assigned_time\", \"First Assigned Time\"},\n            {\"first_assigned_duration\", \"First Assigned Duration\"},\n            {\"resolved_duration\", \"Resolved Duration\"},\n            {\"first_replied_duration\", \"First Replied Duration\"},\n            {\"closed_duration\", \"Closed Duration\"}\n        },\n        MissingField.Ignore\n    )\nin\n    RenamedColumnsTable<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-76bfc57 e-flex e-con-boxed e-con e-parent\" data-id=\"76bfc57\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-33968fc elementor-widget elementor-widget-text-editor\" data-id=\"33968fc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Once executed you will find the ticket data imported into Power BI.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-92e307f elementor-widget elementor-widget-image\" data-id=\"92e307f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"265\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi-1024x265.webp\" class=\"attachment-large size-large wp-image-31138\" alt=\"\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi-1024x265.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi-300x78.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi-768x199.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi-1536x398.webp 1536w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/ticket-data-imported-in-power-bi.webp 1918w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7cc69b8 elementor-widget elementor-widget-heading\" data-id=\"7cc69b8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Expanding the records of custom fields and survey ratings in Desk365<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9293ff2 e-flex e-con-boxed e-con e-parent\" data-id=\"9293ff2\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-20aeab0 elementor-widget elementor-widget-text-editor\" data-id=\"20aeab0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Power BI offers a flexible way to manage which columns are shown in your reports. If you want to expand the records of custom fields, you can do so by clicking the column icon (located at the top-right corner of the Power BI data preview window) as shown in the image below. A list of all available fields will appear, simply select the columns you want to include and then click OK. You can do the same for survey ratings as well.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9fc784b elementor-widget elementor-widget-image\" data-id=\"9fc784b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"838\" height=\"530\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanding-custom-fields.webp\" class=\"attachment-large size-large wp-image-32261\" alt=\"expanding-custom-fields\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanding-custom-fields.webp 838w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanding-custom-fields-300x190.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanding-custom-fields-768x486.webp 768w\" sizes=\"(max-width: 838px) 100vw, 838px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fec4dc2 elementor-widget elementor-widget-text-editor\" data-id=\"fec4dc2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span data-teams=\"true\">If you need to include additional fields that aren\u2019t visible in the list, you can manually add those fields in the Power Query code. This gives you full control over how your Desk365 data is shaped and displayed, ensuring that your reports include exactly the metrics that matter to you<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78d0921 elementor-widget elementor-widget-image\" data-id=\"78d0921\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"512\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query-1024x512.webp\" class=\"attachment-large size-large wp-image-32262\" alt=\"expanded-query\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query-1024x512.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query-300x150.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query-768x384.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query-1536x768.webp 1536w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/expanded-query.webp 1867w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fefb3 elementor-widget elementor-widget-heading\" data-id=\"b6fefb3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Configure and customize API queries in Power BI<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c037914 elementor-widget elementor-widget-text-editor\" data-id=\"c037914\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b><span data-contrast=\"auto\">1. Base URL<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:319,&quot;335559739&quot;:319}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">The Base URL is the starting point for all API requests. Replace yoursubdomain with your Desk365 helpdesk domain:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><a href=\"https:\/\/yoursubdomain.desk365.io\/apis\/v3\/\"><span data-contrast=\"auto\">https:\/\/&lt;&lt;yoursubdomain&gt;&gt;.desk365.io\/apis\/v3\/<\/span><\/a><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><b><span data-contrast=\"auto\">2. API key<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:319,&quot;335559739&quot;:319}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">Your API key authenticates the requests to Desk365. Find your unique API key in the Desk365 portal:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><ul><li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Go to Settings &gt; Integrations &gt; API and copy your API key.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li><\/ul><p><span data-contrast=\"auto\">Replace the placeholder &lt;&lt;YOUR-DESK365\u2019S-API-KEY&gt;&gt; in the code with your actual API key.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c27a7b3 elementor-widget elementor-widget-image\" data-id=\"c27a7b3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"485\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365-1024x485.webp\" class=\"attachment-large size-large wp-image-32810\" alt=\"desk365-obtaining-api-key-for-helpdesk-desk365\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365-1024x485.webp 1024w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365-300x142.webp 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365-768x364.webp 768w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365-1536x727.webp 1536w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2025\/05\/desk365-obtaining-api-key-for-helpdesk-desk365.webp 1918w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff5d35e elementor-widget elementor-widget-text-editor\" data-id=\"ff5d35e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b><span data-contrast=\"auto\">3. Ticket count<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:319,&quot;335559739&quot;:319}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">The ticket_count parameter determines how many tickets are retrieved per API call. You can choose from the following values:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><ul><li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">30, 50, or 100 tickets per API call.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li><li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">The maximum limit for ticket retrieval is 10,000 tickets per hour.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-04501b0 e-flex e-con-boxed e-con e-parent\" data-id=\"04501b0\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a9fd3ef elementor-widget elementor-widget-text-editor\" data-id=\"a9fd3ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><b><span data-contrast=\"auto\">4. Query parameters<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:281,&quot;335559739&quot;:281}\">\u00a0<\/span><\/p><p aria-level=\"3\"><span data-contrast=\"auto\">The Desk365 API includes several query parameters that allow you to retrieve and customize the data based on your reporting and analytical needs. Here\u2019s a detailed explanation of each parameter:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559685&quot;:0,&quot;335559738&quot;:281,&quot;335559739&quot;:281}\">\u00a0<\/span><\/p><ul><li data-leveltext=\"-\" data-font=\"Aptos\" data-listid=\"8\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Aptos&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b><span data-contrast=\"auto\">include_description<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:80,&quot;335559739&quot;:40}\">\u00a0<\/span><\/li><\/ul><p>The description parameter in the Desk365 API not only controls whether ticket descriptions are included in the response but also provides flexibility in the format of the ticket details retrieved.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f8cbb2 elementor-widget elementor-widget-code-highlight\" data-id=\"8f8cbb2\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>include_description = \"1\",                 \/\/ Include description in the response<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b82fb24 elementor-widget elementor-widget-text-editor\" data-id=\"b82fb24\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>When enabled, the API offers two distinct fields for ticket descriptions:<\/p><p><strong>1. Description (HTML)<\/strong> &#8211; The description field contains the full content of the ticket&#8217;s description in HTML format. This field preserves any formatting applied to the text, such as bold, italic, lists, links, or other HTML elements.<\/p><p>2. <strong>Description text (Plain text) <\/strong>&#8211; The description_text field provides the plain text version of the ticket description, stripping away all HTML tags and presenting only the raw content.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c30ca1 elementor-widget elementor-widget-text-editor\" data-id=\"7c30ca1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><b><span data-contrast=\"auto\">include_custom_fields<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:319,&quot;335559739&quot;:319}\">\u00a0<\/span><\/li><\/ul><p>The include_custom_fields parameter enables the retrieval of additional, customized data associated with tickets in Desk365. By default, this parameter is set to 0, meaning custom fields are excluded from the API response. To include custom field data, set the parameter to 1.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48d84b1 elementor-widget elementor-widget-code-highlight\" data-id=\"48d84b1\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>include_custom_fields = \"1\",              \/\/ Include custom fields in the response<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2382d9d elementor-widget elementor-widget-text-editor\" data-id=\"2382d9d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Custom fields in Desk365 are uniquely identified by the prefix cf_ (e.g., cf_Players, cf_Sports). This ensures that these fields are easily distinguishable in the dataset and simplifies the process of mapping them to specific filters or analytics in Power BI.<\/p><p>Desk365 empowers users to define their own custom ticket fields to capture essential information beyond standard fields. Custom fields can be created in the Desk365 agent portal under Settings &gt; Admin &gt; Ticket Fields.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26f3af9 elementor-widget elementor-widget-text-editor\" data-id=\"26f3af9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li data-leveltext=\"-\" data-font=\"Aptos\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Aptos&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b><span data-contrast=\"auto\">include_survey_details<\/span><\/b><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:80,&quot;335559739&quot;:40}\">\u00a0<\/span><\/li><\/ul><p>The include_survey_details parameter allows you to retrieve customer feedback collected through surveys as part of the API response. By default, this parameter is set to 0, meaning survey data is excluded. To include survey feedback, set this parameter to 1.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5b9da00 elementor-widget elementor-widget-code-highlight\" data-id=\"5b9da00\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>include_survey_details = \"1\",            \/\/ Include survey details in the response<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1124e07 elementor-widget elementor-widget-text-editor\" data-id=\"1124e07\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p data-pm-slice=\"0 0 []\">Survey fields in the API response are prefixed with sv_ (e.g., sv_rating, sv_question) for easy identification. These fields provide valuable insights into customer satisfaction, service quality, and agent performance. You have the flexibility to tailor the survey data included in your reports.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de7e51b elementor-widget elementor-widget-text-editor\" data-id=\"de7e51b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li data-leveltext=\"-\" data-font=\"Aptos\" data-listid=\"11\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Aptos&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;-&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b>Sorting parameters<\/b>\u00a0<\/li><\/ul><p aria-level=\"5\"><b><span data-contrast=\"auto\">order_by<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:333,&quot;335559739&quot;:333}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">The order_by parameter defines the attribute by which tickets are sorted. You can choose to sort tickets based on either their created_time (the date and time a ticket was opened) or their updated_time (the date and time the ticket was last modified). This helps prioritize the data display based on your reporting objectives. For instance, sorting by created_time is useful for analyzing ticket volume over a period, while sorting by updated_time helps monitor ongoing or recently resolved tickets.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1adbb24 elementor-widget elementor-widget-code-highlight\" data-id=\"1adbb24\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>order_by = \"created_time\",  \/\/ Sort tickets by \"created_time\" or \"updated_time\"<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd1c045 elementor-widget elementor-widget-text-editor\" data-id=\"cd1c045\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p aria-level=\"5\"><b><span data-contrast=\"auto\">order_type<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:333,&quot;335559739&quot;:333}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">The order_type parameter specifies the direction of sorting:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><ul><li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"7\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Use asc for ascending order. This will display the oldest tickets first.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li><li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"7\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559683&quot;:0,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Use desc for descending order. This will display the newest tickets first.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li><\/ul><p><span data-contrast=\"auto\">Combining order_by with order_type provides flexibility in how tickets are organized, making it easier to focus on specific data subsets like newly created tickets or recently updated ones.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ad2d785 elementor-widget elementor-widget-code-highlight\" data-id=\"ad2d785\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>order_type = \"desc\",     \/\/ Specify the sorting order \"asc\" (ascending) or \"desc\" (descending)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8cf02ac elementor-widget elementor-widget-text-editor\" data-id=\"8cf02ac\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><b><span data-contrast=\"auto\">Filtering tickets by date and time using the \u201cupdated_since\u201d parameter<br \/><\/span><\/b><\/li><\/ul><p>If you want to retrieve tickets updated after a specific date and time, simply use the \u201cupdated_since\u201d parameter in this format \u201cyyyy-mm-dd hh:mm:ss\u201d into your code within the advanced editor for both functions. This addition ensures that only tickets updated from the specified date will be displayed.<span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e2f289 elementor-widget elementor-widget-code-highlight\" data-id=\"7e2f289\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>updated_since = \"yyyy-mm-dd hh:mm:ss\"   \/\/ Filter tickets with activity since the specified timestamp<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1ed8826 e-flex e-con-boxed e-con e-parent\" data-id=\"1ed8826\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5c42f9d elementor-widget elementor-widget-text-editor\" data-id=\"5c42f9d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW244696440 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW244696440 BCX0\">Note:\u00a0When using\u00a0\u201c<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW244696440 BCX0\">updated_since<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">\u201d\u00a0parameter\u00a0<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">indicate<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">\u00a0the specific date and time from which you want to\u00a0<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">showcase<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">\u00a0your tickets such as\u00a0\u201c<\/span><span class=\"NormalTextRun SpellingErrorV2Themed SCXW244696440 BCX0\">updated_since<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">=202<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">4<\/span><span class=\"NormalTextRun SCXW244696440 BCX0\">-11-01 00:00:00\u201d.<\/span><\/span><span class=\"EOP SCXW244696440 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8bab302 elementor-widget elementor-widget-heading\" data-id=\"8bab302\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Source mapping\n<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6201689 elementor-widget elementor-widget-text-editor\" data-id=\"6201689\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This Power Query code shows how numerical codes (constants) for ticket source and priority are mapped to human-readable text labels using mapping tables and joins.<\/p><p>In the first part of the code, the ticket source constants (like 1, 5, 6, etc.) are mapped to corresponding labels such as \u201cEmail\u201d, \u201cMicrosoft Teams\u201d, and \u201cSupport Portal\u201d.<\/p><p>A similar approach is applied to map the priority levels.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a15f674 elementor-widget elementor-widget-code-highlight\" data-id=\"a15f674\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>\/\/ Source mapping table\n    SourceMappingTable = #table({\"Key\", \"Value\"}, {\n        {1, \"Email\"},\n        {5, \"Microsoft Teams\"},\n        {6, \"Support Portal\"},\n        {7, \"Phone or Other\"},\n        {12, \"Web Form\"},\n        {13, \"Web Widget\"}\n    }),\n \n    \/\/ Join SourceMappingTable to SelectedColumnsTable on source\n    MergedSource = Table.NestedJoin(\n        SelectedColumnsTable, \"source\",\n        SourceMappingTable, \"Key\",\n        \"SourceMapping\", JoinKind.LeftOuter\n    ),\n \n    \/\/ Expand the mapped value\n    ExpandedSource = Table.ExpandTableColumn(MergedSource, \"SourceMapping\", {\"Value\"}, {\"source_text\"}),\n \n    \/\/ Priority mapping table\n    PriorityMappingTable = #table({\"Key\", \"Value\"}, {\n        {1, \"Low\"},\n        {5, \"Medium\"},\n        {10, \"High\"},\n        {20, \"Urgent\"}\n    }),\n \n    \/\/ Join PriorityMappingTable to ExpandedSource on priority\n    MergedPriority = Table.NestedJoin(\n        ExpandedSource, \"priority\",\n        PriorityMappingTable, \"Key\",\n        \"PriorityMapping\", JoinKind.LeftOuter\n    ),\n \n    \/\/ Expand the mapped value\n    ExpandedPriority = Table.ExpandTableColumn(MergedPriority, \"PriorityMapping\", {\"Value\"}, {\"priority_text\"}),\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-fe4df45 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fe4df45\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2245a64\" data-id=\"2245a64\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-39bfff7 elementor-widget elementor-widget-heading\" data-id=\"39bfff7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Integrate Desk365 with other applications using the Desk365 API.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85acc9b elementor-widget__width-auto elementor-widget-mobile__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"85acc9b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Explore our endpoints ranging from<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-603edc4 elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"603edc4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Tickets<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4754a10 elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"4754a10\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Contacts<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-678e6f0 elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"678e6f0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Companies<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b47f5e3 elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"b47f5e3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Time entries<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0cb641d elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"0cb641d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Surveys<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d89b3b1 elementor-widget__width-auto elementor-widget elementor-widget-text-editor\" data-id=\"d89b3b1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Contracts<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-437393b elementor-widget elementor-widget-button\" data-id=\"437393b\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/apps.desk365.io\/apis\/api-docs.html\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">OPEN API DOCS<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-f1d8193 e-flex e-con-boxed e-con e-parent\" data-id=\"f1d8193\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ebdd4e5 elementor-widget elementor-widget-heading\" data-id=\"ebdd4e5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Impactful reports from raw data <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b33fc9b e-flex e-con-boxed e-con e-parent\" data-id=\"b33fc9b\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d929bbd elementor-widget elementor-widget-text-editor\" data-id=\"d929bbd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span data-contrast=\"auto\">Finally, you can use the Power BI tool to transform these raw data into actionable insights, enabling better decision-making, data-driven strategies, and improved business performance.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-contrast=\"auto\">For instance, here you may see the sample report generated for \u2018No. of tickets vs status\u2018<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5ba8302 e-flex e-con-boxed e-con e-parent\" data-id=\"5ba8302\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-111eafb elementor-widget elementor-widget-image\" data-id=\"111eafb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"983\" height=\"712\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-status.jpg\" class=\"attachment-large size-large wp-image-29502\" alt=\"power-bi-number-of-tickets-vs-status\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-status.jpg 983w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-status-300x217.jpg 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-status-768x556.jpg 768w\" sizes=\"(max-width: 983px) 100vw, 983px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dca2081 elementor-widget elementor-widget-text-editor\" data-id=\"dca2081\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW37211978 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW37211978 BCX0\">Here is another report depicting the bar graph for \u2018No. of tickets vs <\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW37211978 BCX0\">groups\u2018<\/span><span class=\"NormalTextRun SCXW37211978 BCX0\">.<\/span><\/span><span class=\"EOP SCXW37211978 BCX0\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9332534 e-flex e-con-boxed e-con e-parent\" data-id=\"9332534\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-92482fb elementor-widget elementor-widget-image\" data-id=\"92482fb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"706\" src=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-group.jpg\" class=\"attachment-large size-large wp-image-29503\" alt=\"power-bi-number-of-tickets-vs-grouppower-bi-number-of-tickets-vs-group\" srcset=\"https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-group.jpg 985w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-group-300x215.jpg 300w, https:\/\/help.desk365.io\/en\/wp-content\/uploads\/2024\/11\/power-bi-number-of-tickets-vs-group-768x550.jpg 768w\" sizes=\"(max-width: 985px) 100vw, 985px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bfbf211 e-flex e-con-boxed e-con e-parent\" data-id=\"bfbf211\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7701de4 elementor-widget elementor-widget-text-editor\" data-id=\"7701de4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span class=\"TextRun SCXW220599003 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW220599003 BCX0\">Integrating Desk365 with Power BI is a strategic move for any organization looking to <\/span><span class=\"NormalTextRun SCXW220599003 BCX0\">leverage<\/span><span class=\"NormalTextRun SCXW220599003 BCX0\"> its helpdesk data for better customer support and operational efficiency. Embrace the power of <\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2Themed SCXW220599003 BCX0\">data, and<\/span><span class=\"NormalTextRun SCXW220599003 BCX0\"> watch your customer support operations reach new heights with Desk365 and Power BI integration.<\/span><\/span><span class=\"EOP SCXW220599003 BCX0\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:0,&quot;335551620&quot;:0,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-df46492 e-flex e-con-boxed e-con e-parent\" data-id=\"df46492\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"author":16,"featured_media":0,"parent":18745,"menu_order":13,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-29509","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/29509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/comments?post=29509"}],"version-history":[{"count":108,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/29509\/revisions"}],"predecessor-version":[{"id":36228,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/29509\/revisions\/36228"}],"up":[{"embeddable":true,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/18745"}],"next":[{"title":"Setting up user provisioning in Microsoft Entra ID for Desk365","link":"https:\/\/help.desk365.io\/en\/articles\/setting-up-user-provisioning-in-microsoft-entra-id\/","href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/30104"}],"prev":[{"title":"Configure the Desk365 Connector in Microsoft Copilot Studio","link":"https:\/\/help.desk365.io\/en\/articles\/configure-desk365-connector-in-microsoft-copilot-studio\/","href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/docs\/35403"}],"wp:attachment":[{"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/media?parent=29509"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.desk365.io\/en\/wp-json\/wp\/v2\/doc_tag?post=29509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}