Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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

Submitted by Anonymous on ‎03-14-2019 02:52 PM

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
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎03-15-2019 01:55 AM

@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

Anonymous
Not applicable
‎03-15-2019 01:55 AM
 
Anonymous
Not applicable
‎03-15-2019 07:37 AM

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
‎03-19-2019 06:23 PM

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.

Idea Statuses