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
The reason you're seeing all nulls is because, in your case, ReleaseType isn't a record; it's already a plain text value (like "Major"). This occurs because SharePoint automatically simplifies lookup fields when the source list only has one column (such as just Title). Do not attempt to expand or extract [Title]. Instead, use the ReleaseType column as it is ,it's already a simple text value containing your lookup (such as "Major", "Fix", etc.). There is no need for any custom column formulas for this field. Simply rename the ReleaseType column if you prefer a cleaner name and proceed with your transformations as usual.
I have included the official Microsoft documentation for your reference:
Power Query SharePoint list connector - Power Query | Microsoft Learn
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.
Hi
As you can see in my screenshot from Power BI it shows as a record, NOT plain text...
I can not expand the column as it reports no columns were found
If you are looking at the screenshot that shows it as actual value, then this is NOT in power BI, but directly in SharePoint as the list:
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):
