Forum Discussion
ADO null return in Powerbi
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