Problems connecting to Visual Studio Team services

[sc_bperry]

Our organization cannot fully connect to our Visual Studio Team Services project using the VSTS connector in the Power BI web version using the instructions at https://docs.microsoft.com/en-us/vsts/report/powerbi/connect-vso-pbi-vs. We are able to login with the connector and it appears to begin importing the data, but we receive the following error the dashboard renders empty tiles. We do have customized work items in our project. Is this what is causing this particular error?

We couldn't import data from Visual Studio Team Services
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Processing errorTransaction cannot be committed because database with name='***', Id='***' is disabled for scoped connections.
Activity ID ***
Correlation ID ***
Request ID ***
Status code 500
Time Tue Oct 24 2017 15:31:04 GMT-0400 (Eastern Daylight Time)
Version 13.0.2819.181
Cluster URI https://wabi-us-east2-redirect.analysis.windows.net

[v-qiuyu-msft]

Hi @sc_bperry,

Please try to use the Visual Studio Team Services connector in Power BI desktop to see if the same issue occur. 

If the issue only happens on VSTS content pack, please run Fiddler and repeat the steps to get VSTS content pack, share .saz file with us. 

Best Regards,
Qiuyun Yu 

[sc_bperry]

Thanks, Qiuyun. I get the following error when I attempt to get data from the Visual Studio Team Services connector in Power BI Desktop:

Details: "The Analytics OData endpoint is in preview and only available to select customers of Visual Studio Team Services at this time. If your account has been enabled please contact the Microsoft employee who setup the service for assistance."

We are not in the preview program. Is there a way we can join?

Thanks,

Blaine

[sc_bperry]

I was able to join the next preview cycle in November, but I am still having the problem with Power BI on the web.

[v-qiuyu-msft]

Hi @sc_bperry,

So your account Analytics OData endpoint has been enabled, right? 

Please see below information from PG team: 

We do not recommend using the Power BI Content Pack(being deprecated on Nov 15) or the Power BI Desktop Connector at this time. Using OData endpoint directly in Power BI allows for a lot more flexibility on what data is included in the model and that approach is also much less likely to be impacted by any upcoming changes.

We are working on a new feature we are tentatively calling “Analytics Views” which is designed to make getting your data into Power BI much easier, which will replace the existing Power BI Desktop connector. We expect to ship this new feature in the January timeframe.

The customer will need to make sure the Analytics Extension is installed before using OData - https://marketplace.visualstudio.com/items?itemName=ms.vss-analytics.

Examples of how to use the Power BI extension (VSTS.Feed) can be found here: https://www.visualstudio.com/en-us/docs/report/powerbi/data-connector-functions

A general overview of the OData endpoint can be found here: https://www.visualstudio.com/en-us/docs/report/analytics/overview-analytics-service

A more detailed overview of the aggregations we support can be found here: https://www.visualstudio.com/en-us/docs/report/analytics/aggregated-data-analytics

Best Regards,
Qiuyun Yu

[sc_bperry]

Hi @v-qiuyu-msft,

How do I determine if our Analytics OData endpoint is enabled? We have installed the Analytics Extension for our VSTS account. Is that the same thing? (Sorry for my ignorance, but the VSTS Reporting documentation is sparse and I'm not fully grasping it. There's no real "overview" section so I have to [unsuccessfully] infer a lot from it.)

I tried testing the first VSTS.Feed Power BI extension example, replacing my account and project, but I get the following error:

Error: The Analytics OData endpoint is in preview and only available to select customers of Visual Studio Team Services at this time. If your account has been enabled please contact the Microsoft employee who setup the service for assistance.

Do I need to wait until we are in the next Power BI Data Connector preview cycle in the middle of this month?

[v-qiuyu-msft]

Hi @sc_bperry,

Would you please share your VSTS account URL? So I can sent this to PG internally to check if your account Analytics OData endpoint is enabled. 

Best Regards,
Qiuyun Yu

[sc_bperry]

Hi @v-qiuyu-msft, I sent the URL in a private message. Thanks!

[v-qiuyu-msft]

Hi @sc_bperry,

I have sent this information to PG team to consult this issue. Will let you know if I get any information. 

Best Regards,
Qiuyun Yu

[sc_bperry]

Thanks!

[v-qiuyu-msft]

Hi @sc_bperry,

The account has not been setup with OData yet. The preview should be available by Monday. And PG team will reach out to me as soon as the account is ready along with providing some guidance on how to get started. I will update here once I get information again. 

Best Regards,
Qiuyun Yu