Forum Discussion
Days between two dates
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.
@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.
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
