oscarvalerock / clockify-powerbi Goto Github PK

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.

I ensured the connector is where the gateway can read it, but it is giving me this error:

Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.

I am using the template, and we are not hosted on-site.

Really appreciate your support!

We use the custom connector to get data from the Clockify API. Everything works fine on PowerBI desktop, but when we turn on the automatic refresh on the PowerBI service the dataset fails to refresh. The error is the following:

Data source error: Column 'Project ID' in Table 'Projects' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
Cluster URI: WABI-NORTH-EUROPE-L-PRIMARY-redirect.analysis.windows.net
Activity ID: 5ab5cd08-66ba-46d0-822b-3b44b97a0a93
Request ID: 22beef8f-e799-493b-b9b1-d7d5564a79d5
Time: 2022-12-14 07:18:37Z

We have tried everything that could:

1. Re-installed the custom connector on the getaway
2. Updated the getaway
3. Removed all the blank and duplicate values from every table with PowerQuery
4. Removed the mentioned table, but then we got the same error message for another table.

Also, some times when we upload the dataset with no relationships it refreshes the data, but it returns blank tables.

Hi,
I am facing an issue where I cannot add gateway data source credentials. Getting error:

Details:

1. Using MEZ connector, data in PowerBI Desktop syncs successfully.
2. Added MEZ connector to on-prem PowerBI Gateway.
3. I can add PowerBI Gateway from the service, but cannot add the credentials, I am specifyig the same Clockify API key, which works for PowerBI Desktop.

Any suggestions?

Greetings,

The template worked wonderfully while we stayed on clockify free. However, we've recently upgraded to Pro Plan, and the new modules like expenses or time-off, won't show up in Power BI.

I'll be grateful if anyone knows any kind of solution.

Hi,
Iam using power bi and clokify connector for the past few months , and it was working properly .But from yesterday onwards its starts showing some error like below.

DataSource.Error: Web.Contents failed to get contents from 'https://api.clockify.me/api/v1/workspaces/5be008f2b0798754befe2030/projects/6218b9516a6eba63b0fe4df0/tasks?page-size=5000' (400): Bad Request
Details:
DataSourceKind=Clockify
DataSourcePath=Clockify
Url=https://api.clockify.me/api/v1/workspaces/5be008f2b0798754befe2030/projects/6218b9516a6eba63b0fe4df0/tasks?page-size=5000

Can you please help

Thanks

Hi @OscarMartinezV / @OscarValerock ,

It seems Clockify have updated their API and broken things again ... On the 18th May 2022 they:

Updated default parameter for "Find all users on workspace" from ALL to NONE

This means that the call to get Users that the Power BI File / Plugin does no longer returns Membership information that is used to get the users Hourly Rate.Amount and Hourly Rate.Currency.

To solve this we need to change the current api call made from:

"/api/v1/workspaces/"&workspaceid&"/users?page-size=200"

to

"/api/v1/workspaces/"&workspaceid&"/users?page-size=200&memberships=ALL"

This then makes the users call behave like it used to before they changed the default and that all expected properties are populated.

If I get chance I'll do a PR to fix this!

The Clockify API seems to have had a change introduced that now makes the Time Entries endpoint give an error of Bad Request if you request a page-size of 100000 like the template currently does in the Time Entries Fx function.

Changing this to 5000 makes it work again but may be too low for a lot of use cases.

(Workspace,User)=>

let
    Source = Json.Document(
        Web.Contents(
            "https://api.clockify.me",
            [
                RelativePath = "/api/v1/workspaces/"&Workspace&"/user/"&User&"/time-entries?page-size=5000", 
                Headers=[
                    #"X-Api-Key"=(#"X-Api-Key")
                ]
            ]
        )
    ),
// .... Extra code removed for brevity

I've messaged Clockify to see if this change was intentional (as it's not listed in their API changelog and seems to be the way they themselves have suggested doing it) and if it is, what the maximum value is.

If it is intentional though the template may now need to loop getting more pages until there is no more to get! ... only issue will be the 10 reqs / second API limit so there may have to be some waiting introduced if that is possible in Power Query!...

I'll wait to see what they come back with and update here!

Data is ok in the Power Query but it doesn't load do the power BI editor. These are the errors report:

Workspaces
O carregamento foi cancelado devido a um erro no carregamento de uma tabela anterior.
Users
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Clients
A coluna "Client ID" na Tabela "Clients" contém valores em branco, o que não é permitido em colunas do lado de uma relação de muitos para um ou em colunas que são utilizadas como a chave primária de uma tabela.
Projects
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Tasks
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Time Entries
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Time Entries Tags
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Tags
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
00 Measures
O carregamento foi cancelado devido a um erro no carregamento de uma tabela anterior.
Detailed Report
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.
Detailed Report Tags
Erro OLE DB ou ODBC: Excepção de HRESULT: 0x80040E4E.