Days between two dates

[BrightSoul]

Hello everyone,

I started using Power BI (Service) to visualize some data imported from a Visual Studio Online Project.

In particular, I'd like to see how many days it took for us devs to resolve each bug that came up in that project.

In the natural language query I've typed the following.

show bugs created date and closed date

...which displays a nice table with two columns, the created date and the closed date for each bug, all of them provided by the Visual Studio Online data set.

Now I need a third calculated column displaying the difference in days between those two dates.

Is that possible? If not, is it a planned feature?

Thanks.

Moreno

[Greg_Deckler]

You can't create a calculated field in the Service, you would have to connect to Visual Studio Online through something like Excel or Power BI Desktop, import the data, create your calculated fields and then upload to the Service. I doubt you could get the Q&A engine to understand that you want the difference between those two dates.

[BrightSoul]

---

@smoupre wrote:

you would have to connect to Visual Studio Online through something like Excel or Power BI Desktop, import the data, create your calculated fields and then upload to the Service.

---

Thank you so much. Yes, that would solve problem.

Unfortunately, as of today, both Power BI Desktop and and Excel don't seem to be able to connect to Visual Studio Online. I wonder why, since lots of other online services such as Facebook, Google Analytics, Github (and others) are available.

I should just wait for support, perhaps?

Thanks.

[clement]

Hello BrightSoul,

I searched for the same feature.

6 months later it is still not available.

PowerBI Desktop still does not allow to connect to Visual Studio Online.

Excel 2013 still does not allow to connect to Visual Studio Online.

Power BI in Office365 allows to connect to Visual Studio Online. It uses the REST API and oAuth2 to authenticate:

https://www.visualstudio.com/integrate/get-started/auth/oauth

I hope Microsoft will release it soon, they did add the Azure Active Directory Group support to VSO last week so VSO stil lives.

a+,=)

-=Clement=-

Configuration :

PowerBI Desktop v2.27.4163.701

Excel 2013