search

OscarValerock / Clockify-PowerBI

This repository contains the project for a Power BI Custom connector that connects to Clockify
MIT License
14 stars 5 forks source link

OLE DB or ODBC Error #16

Closed AlexP524 closed 2 weeks ago

AlexP524 commented 4 months ago

Hi Oscar. A huge thank you for this tool! Its a great help. Unfortunately, I ran into an issue today. I noticed that it was only pulling in 500 of our project records from Clockify. We have over 2500. So I changed the PageSize parameter to 5000 and now when I apply the changes I get the following:

OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://reports.api.clockify.me/v1/workspaces/61a64c350b6d292c343f4465/reports/detailed' (400): Bad Request.

Any suggestions? TIA.

OscarValerock commented 2 months ago

You seem to have a pagination issue. Hey Alex, are you using the MEZ connector or a query you wrote?

OscarValerock commented 2 weeks ago

Hi @AlexP524 Please refer to this issue where I will follow up on the connection issues.