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

Gateway data source credentials cannot be added #14

Closed Peteris-E closed 11 months ago

Peteris-E commented 11 months ago

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

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?

Peteris-E commented 11 months ago

Actually, I was able to solve the issue with the help of these to article and a bit of community: https://docs.microsoft.com/en-us/power-query/handlinggatewaysupport https://docs.microsoft.com/en-us/power-query/samples/trippin/9-testconnection/readme

I added TestConnection line to the connector: image

OscarValerock commented 11 months ago

Hey @Peteris-E , thanks a lot for the solution! I've modified the code in the project and the MEZ file.