ADO null return in Powerbi

[charlieman]

Hi All, I can do with some help, please. I have a custom field called process map in ADO which contains data. However, when I opwn the colunm in power query, it returns a null value. does anyone have any idea why this could be happening?

thanks in advance

[Anonymous]

Hi @charlieman ,
According to your description, the field in your Azure DevOps has data, but it shows up as null in the power query.To resolve this issue. First, you need to make sure that the data type of the custom field in Azure DevOps (ADO) is compatible with Power Query. A mismatched data type will not be recognized by Power Query. Second , verify that the custom field is visible and accessible in the dataset imported into Power Query. Sometimes, fields may be hidden or not included in the query. Finally, check that you have the necessary permissions to access the custom field data in ADO. Lack of permissions may result in null values.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Omid_Motamedise]

can you share the image of the column befor expanding?

[suparnababu8]

@charlieman 

Check Data Type: Verify the data type of the custom field in Azure DevOps. If it’s a complex type like HTML, consider converting it to a simpler type before importing it into Power BI. 

try to adjust Adjust Privacy Settings: Go to File > Options and settings > Data source settings in Power BI, and adjust the privacy levels for your data sources.