Connecting to Sharepoint List - leaves out a column

[AmberH]

Hello,

I am trying to do some reporting off of 2 lists that I have created and populated.

When I connect to the data from Power BI Desktop, I am missing a column - one that is important to my reporting.

If it matters, this column was the most recently added column - has lots of null values.

I chose 'transform data' and the column isn't there.

Any suggestions how I can have it pull ALL of my columns?

Thanks,

Amber

[v-echaithra]

Hi @AmberH ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E.

[v-echaithra]

Hi @AmberH ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E.

[v-prasare]

HI @AmberH,

Thanks for reaching MS fabric community support

--> Check Query Editor for Column Detection -->Open Power Query Editor (Transform Data) --> Click on "Advanced Editor" in the ribbon. check for 
Table.SelectColumns(YourTable, {"Column1", "Column2", ...}). if not found column add manually if you have access to the column Refresh Preview & Apply Changes
--> In Power Query, check the Applied Steps pane for a "Removed Columns" step.

thanks,

Prashanth

[AmberH]

Thanks Prashanth,

In Advanced Editor - it doesn't list the individual columns brought in to the report (see below).

It does show the removed columns (I did remove these) - but doesn't include the one I'm missing.

let
Source = SharePoint.Tables("https://my sharepoint list", [ApiVersion = 15]),
#"29156a10-8e44-4d03-a5c3-6da3ae631ba1" = Source{[Id="29156a10-8e44-4d03-a5c3-6da3ae631ba1"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"29156a10-8e44-4d03-a5c3-6da3ae631ba1",{{"ID", "ID.1"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"ServerRedirectedEmbedUri", "FileSystemObjectType", "ContentTypeId", "OData__ColorTag", "ComplianceAssetId", "Modified", "Created", "OData__UIVersionString", "Attachments", "GUID", "FirstUniqueAncestorSecurableObject", "RoleAssignments", "AttachmentFiles", "ContentType", "GetDlpPolicyTip", "FieldValuesAsHtml", "FieldValuesAsText", "FieldValuesForEdit", "File", "Folder", "LikedByInformation", "ParentList", "Properties", "Versions", "Author", "Editor"})
in
#"Removed Columns"

[v-prasare]

Hi @AmberH,

Thanks for quick response

1. Clear and Reconnect to the Data Source. Remove the existing SharePoint connection. Reconnect and ensure all columns are pulled in from the start.

2. Check Column Visibility in SharePoint--> Go to SharePoint List Settings → Columns and check if the column is hidden. If hidden, make it visible and refresh Power BI.

3. Use Table.ColumnNames() to Identify Missing Columns
In Power Query Editor, add a new step:
Edit
= Table.ColumnNames(Source)
This will list all available columns in the data source.

If your column isn’t in the list, it’s likely a SharePoint issue.

4. Load Data into a Staging Table Instead of transforming the data immediately, load the raw SharePoint data into a separate Power BI table.

Then, check if the column appears before applying transformations.

5. Check Column Data Type Compatibility, If the column has mixed or unsupported data types, Power BI might exclude it.

6. Increase API Version in Query In Advanced Editor, modify your query:
Try changing ApiVersion from 15 to 14 or 16 to see if it retrieves missing columns.

7. Manually Add the Column in Power Query
If Power BI still doesn’t detect it, manually add it:

#"Added Custom Column" = Table.AddColumn(Source, "MissingColumn", each null)
This ensures the column exists and can receive data upon refresh.

Thanks,

Prashanth Are

[pankajnamekar25]

Hello @AmberH 

Refresh the Data – In Power Query, click Refresh Preview.

Check Applied Steps – Look for "Removed Columns" or "Selected Columns" steps.

Force Schema Refresh – Reconnect the data source and refresh.

Delete & Reconnect – Remove and re-add the data source in Power Query.

Check Permissions – Ensure you have access to the new column.

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos, it would be greatly appreciated.