topic Re: Connection type in Report Server

Connection type

STANHTPS — Mon, 06 Jan 2025 12:36:34 GMT

Hello,

Please, what type of connection should I use choose for opsgenie in Admin center with cluster gateways for cloud PBI ?It should be WebApi or RestApi, but both these types are not included in the list...only Web, and it looks like the classic URl.

Example :

"https://api.opsgenie.com/............

Thank you.

Re: Connection type

lbendlin — Mon, 06 Jan 2025 14:06:35 GMT

You connect to these sources via "Web" using Web.Contents https://learn.microsoft.com/en-us/powerquery-m/web-contents

Re: Connection type

Anonymous — Tue, 07 Jan 2025 08:53:44 GMT

Hello,lbendlin,thanks for your concern about this issue.

Your answer is excellent.
Hi,@STANHTPS .I am glad to help you.
I agree with lbendlin's suggestion.
I found posts related to connecting data sources to power BI, and the advice given uses the connection method of Web.

Web.Contents()

URL:
Opsgenie integration with PowerBI using Rest API

You can try to mark lbendlin's suggestion as a solution,which will help other users in the forum.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

Re: Connection type

STANHTPS — Thu, 09 Jan 2025 12:04:27 GMT

Hello, thanks.

So i choosed the connection type: Web

But, another thing is the right choose of Aut. method.

options are:

Anonymus, Basic, Windows, OAuth 2.0, Service Principal.

In Docu is to choose api key method, i got api key but dont have the option to put in.

As you can see, after i fill in the URL, I need to choose authentication Method.

Re: Connection type

lbendlin — Thu, 09 Jan 2025 14:56:47 GMT

Anonymous

Re: Connection type

STANHTPS — Fri, 10 Jan 2025 10:48:52 GMT

That is exactly what we do in reports, but still the connection with anonymous not working, the api key is in the URL, so what could be the problem.. test connection is failing:

Unable to update connection credentials. Invalid connection credentials.

Details: cluster data gateway City: The credentials provided for the Web source are invalid. (Source at https://api.eu.opsgenie.com/v2/schedulescluster data gateway City 2: The credentials provided for the Web source are invalid. (Source at https://api.eu.opsgenie.com/v2/schedules

And in desktop client, its working fine.

Re: Connection type

lbendlin — Fri, 10 Jan 2025 15:30:35 GMT

The documentation has an example for API Key connections.