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

Can't add https://reports.api.clockify.me/v1 to gateway #12

Closed The-Power-BI-Guy closed 2 weeks ago

The-Power-BI-Guy commented 11 months ago

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!

The-Power-BI-Guy commented 11 months ago

Just wanted to follow-up on this. I noticed it seems to derive from the Details report based on the parameters set up. All of the other tables will refresh, but I like how the details report pulls the information together and would like to continue to utilize the template as it's been set up.

OscarValerock commented 11 months ago

Which is the connection you are using, the *.PBIT file or the MEZ? I just tested both, PBIT and MEZ files, both connections are working fine; could not replicate any error.

image

If you are using the MEZ file, you need to create the connection on the gateway before being able to refresh. Gateway is ready when in the gateway you see the connector listed.

image

In this video you will see how to create a gateway connection of a different custom connector.

https://youtu.be/n6_Gc35heuk?si=cuypML9GC28ng1W3&t=686

The-Power-BI-Guy commented 11 months ago

Thank you for the quick reply, Oscar! :)

So I'm using the PBIT file, and my custom connector is showing on the gateway.

It's this specific website callout that is giving me an error (404) when I try to do anything with it.

Oddly enough, the report refreshes from the desktop, just not able to add that data source in the gateway. image

The-Power-BI-Guy commented 11 months ago

Tried to adjust the credentials in the power bi service and this comes up image

OscarValerock commented 10 months ago

For the PBIT file, you do not need a gateway. The only thing you require is the credentials on the data source set-up. Furthermore, the private level should only be used on specific cases, not for general applications.

The-Power-BI-Guy commented 10 months ago

Thank you, Oscar. I really appreciate the support.

So how do you 'remove' the private level? I'd like to keep the information as it's been put together, but don't know how to approach that. I'll work on the credentials piece as well and get back to you.

TinaCastillo09 commented 10 months ago

Tried to adjust the credentials in the power bi service and this comes up image

I have the same error. Did you figure out a way around this?

vvazquezr commented 4 months ago

I have the same problem, don't know which kind of authentication should I use. There is no "Web API" connection type on app.powerbi data credentials page to enter just my API KEY, and I can't use the .mez custom connector since it not appears in the PBI Desktop app, even if I put it under C:\Users\\Power BI Desktop\Custom Connectors folder image

OscarValerock commented 2 weeks ago

Hi @vvazquezr @The-Power-BI-Guy @TinaCastillo09 - Please refer to this issue where I will follow up on the connection issues: