Forum Discussion
Frustrating Power Query Editor and Sharepoint Lists
Hi tknguyen
If the issue still persists we recommend you to raise support ticket.https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this solution helps, please consider giving us Kudos and accepting it as the solution so it can assist other community members.
Thank you.
Hi tknguyen
Thank you for reaching out microsoft fabric community forum.
That error usually means ReleaseType isn't always a record—Power BI might just be seeing a plain value or null, especially if the source list only has one column like Title.
Try using this formula in a custom column:
if [ReleaseType] is record then [ReleaseType][Title] else null
This checks if it’s a record before trying to get the Title, which avoids errors.
Also, in Power Query, click the icon next to the
ReleaseType column name to check its actual data type. If it doesn’t show as a record, that confirms the issue.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you
With the formula, I'm getting null for both entries, which makes no sense at all to me:
Per my previous screenshot of the Sharepoint list as seen in SharePoint, these are the only 2 rows in that list, and both have valid lookup values which I'm posting again: