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

Automatic Refresh does not work #9

Closed vikitsich closed 1 year ago

vikitsich commented 1 year ago

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.

OscarValerock commented 1 year ago

Please confirm this is related to the MEZ file.

vikitsich commented 1 year ago

The problem was due to a bug in PowerBI service, all the datasets that had a gateway connection could not refresh. I did not have to do with the MEZ file.

OscarValerock commented 1 year ago

OK then, I will close this issue. Thanks.