Forum Discussion
Analytics View, power BI & custom multi line fields
Hello good community
How are you ?
I am stuck to find a method to use my multi line custom fields ('description' and others) in power bi. I don't have the ability to put them in in my analytical view. Does anyone have a solution?
thank you in advance
3 Replies
- amitchandak
Super User
ValerienSegard , Not very clear. You can create measure and use that
Measure = 10
measure =11
Or use what if https://docs.microsoft.com/en-us/power-bi/desktop-what-if
Sorry, my question was not so precise
I am trying to retrieve some fields (Description, Acceptance Criteria ...) from the work item type from Azure DevOps to PowerBI.
To make the link between Devops & PowerBi, i made an analytics view in Devops, but i cannot put Text-Based fields (except title) in output of my analytics view.
So my text-based fields in Devops are not 'exported' to Power Bi and i can't use them.
What is the data type of the text based fields in Devops?
If the fields are Plain text or rich-text, you couldn't add them into field.
Form this blog: Select the fields to appear in the report
You can't add fields with a data type of Plain Text (long text) or HTML (rich-text). These fields aren't available from Analytics for the purposes of reporting.
I found some blogs about connect to Azure Devops and build reports.
Blog1: Connect to Analytics with Power BI Data Connector
Blog2: Create a Power BI report with a default Analytics view
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
