Forum Discussion
Change Data Source of Tabular Model to Amazon Redshift
The only working solution I found out is to delete model Data Source and each table Data Source (Legacy) partitions and replace them with M equivalent that is using Power Query native Redshift connector. ( let Source = AmazonRedshift.Database...)
Since my Tabular model is serialized I managed to create quick python script to replace all table partitions with M query.
Hi mandmiADA,
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
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
I believe you made mistake and replied to the wrong post.