cancel
Showing results for 
Search instead for 
Did you mean: 

Jitbit helpdesk and Power BI integration : Issue of duplication and limited records(100)

Hi,

 

we are facing a issue of limited records and duplication for Jitbit helpdesk integration with power Bi. 

below are screenshots i have attached M query 

Pagination.PNGTickets.PNG

Thanks in advance,

 

Status: Needs Info
Comments
v-yuezhe-msft
Microsoft

@Anonymous ,

What do you mean duplication? Could you please share sample data here? What is the result when you connect to the Jitbit helpdesk without setting any parameters in M code?

In addition, I see that your REST API supports count and offset, I would recommend you check the M code in this similar blog to implement pagination.

Regards,
Lydia

v-yuezhe-msft
Microsoft
Status changed to: Needs Info
 
Anonymous
Not applicable

Hi  v-yuezhe-msft,

 

Thanks for your response.

I will go through the M code again.

 

Below is the screenshot for duplicated records.

 

 

new1.PNG

Anonymous
Not applicable

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://petstock.jitbit.com/helpdesk/api/Tickets?count=100&offset=10019734781' (429): .
'.

 

I am getting this error. how to resolve this.

 

thanks in advance.