BETA Azure Enterprise Connector error with PBI Desktop

[Anonymous]

I have been working with the Microsoft Azure Enterprise content pack with Power BI but want to have some more flexibility with the dataset. So, I have been trying to work with the (beta) Azure Enterprise Connector via Power BI Desktop. I have a few observations that I hope someone can comment on;

1. The connection information for the beta connector is somewhat different then the content pack connection. The beta connector requires the azure enterprise REST endpoint (e.g. https://ea.azure.com/rest/12345) whereas the content pack simply requires the 'ea.azure.com' - the problem I am having is finding a REST endpoint that actually works - where can I find the proper endpoint configuration?

I am using the 'free' version of PBI so this may have something to do with what I am seeing but would like to confirm. Some of the wierdness is that I can enter for example 'https://ea.azure.com/rest/' as the endpoint and then I am able proceed to the next screen in the wizard which presents me the usage folder in PBI desktop. However, when I attempt to open one of the folders I get one of two error messages - one tells me that the JSON carries an incorrect element - presumably the endpoint I put in is actually invalid. In the other instance, I receive an error telling me that my API key could not be authorized - which is odd given that the key comes directly from the ea portal.

Does anybody have any thoughts?

[v-caliao-msft]

Hi @Anonymous,

Representational State Transfer (REST) APIs are service endpoints that support sets of HTTP operations (methods), which provide create/retrieve/update/delete access to the service's resources.

The request URI, which consists of: {URI-scheme} :// {URI-host} / {resource-path} ? {query-string}.  Please refer to the link below to see the details about Azure REST API.
https://docs.microsoft.com/en-us/rest/api/

Regards,

Charlie Liao

[Anonymous]

Hi Charlie

Thanks for your quick response but the answer is not really what I am looking for. I am not developing a custom app. I am using Power BI desktop for the Azure Enterprise connector (beta). I find it very strange that I have to use a specific REST call method in order to retrieve the EA usage information so that I can work with it in the desktop tool. Compare this with the experience of using Power BI online, accessing the Microsoft Azure Enterprise content pack where the URI I need to enter is 'https://ea.azure.com' and the API key, no REST method is specifically required. In Power BI online, using the content pack, I get the complete data set and I can begin to create reports. I would expect the desktop connector to operate in exactly the same manner, beta or otherwise. Am I missing something here?

Regards,

Dan

[Anonymous]

Hello All,

Just an update to my problem. I managed to get the correct endpoint defined - it is as follows;

https://ea.azure.com/rest/<enrollmentId>/usage-reports?month=2017-02&type=detail

I would suggest the following however to the team that is evolving the desktop connector;

1. Ensure that the desktop experience is the same as the online experience - as another contributor pointed out (idof) the data set presented in the desktop version is file-by-file whereas the online experience provides a single transparent view of all usage data.

2. Although the above endpoint worked, you will notice that the month specified was targetted at 2017-02&type=detail. The result set returned however was all months for the detail AND the summary sheet and the others as well so you may want to tighten that up abit or (even better) keep it simple and simplify the connection requirement and return all data that a user is entitled to in a single transparent view.

Regards

[Anonymous]

Hello Friends

I am trying to connect to Azure enterprise Beta through Power BI desktop, i have entered Azure ea portal end point details as such https://ea.portal.com/rest/ then i was asked to provide access key, after providing the access key i have encoutered below error         "DataSource.Error:Web.Contents failed to get contents. 

second time when i connected i got following error

"DataSource.Error: The underlying connection was closed: An unexpected error occurred on a send.
Details:
https://ea.portal.com/rest//usage-reports"

Help Much appricated 

[Anonymous]

Well, i thanks jostd, i followed your procidure, and gave the endpoint detials in follwoing manner, 

I managed to get the usage report, 

Just an update to my problem. I managed to get the correct endpoint defined - it is as follows;

https://ea.azure.com/rest/<enrollmentId>/usage-reports?month=2017-02&type=detail