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
It appears that the issue arises from Power BI inconsistently interpreting the ReleaseType column as either a record or a text value. This typically occurs when SharePoint lookup columns are involved, leading to inconsistencies due to the structure of the list or Power Query’s automatic type detection.
To address this, standardize the column to text by applying a transformation. Add this step in the Advanced Editor after the Source step:
= Table.TransformColumns(Source, {{"ReleaseType", each if Value.Is(_, record) then Record.Field(_, "Title") else Text.From(_), type text}})
This approach avoids nulls, handles records and text efficiently, and simplifies your Power Query.
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.
I'm getting an expression error.. can you please confirm what is wrong (NOTE there were no syntax errors detected):