Reply
trademobilemart
New Member
Partially syndicated - Outbound

Issue connecting the Data source

Following Data source error come due to "Shipping" Column in Data might be misplaced or removed from the original CSV file (onedrive).

 

 

{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The column 'Shipping' of the table wasn't found."}}],"exceptionCulprit":1}}} Table: Master Sales History.

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

Syndicated - Outbound

@trademobilemart, open the Edit/Transform Data query.

Right-click the open feed editor in the table. From the column list carefully remove the data-typed column.

If you change the name, rename it there.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @trademobilemart ,

 

Something to look out for is the fact that csv files are imported using a fixed number of columns: the number of columns in the source when first imported. This means that if your source csv has a column added to it, the furthest right column in the file is ignored. Not sure if this is your case, but very useful to know if you're dealing with csv sources nonetheless.

 

You can fix this so that the csv always picks up all columns in the source as follows:

 

In Power Query, go to your source step and completely delete the column value argument here:

csv source remove columns.PNG

So that it now looks like this:

csv source no columns.PNG

 

You will now always import all available columns as they are added to the source.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

3 REPLIES 3
trademobilemart
New Member

Syndicated - Outbound

issue resolved, thanks for providing fix

@BA_Pete 

@amitchandak 

BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @trademobilemart ,

 

Something to look out for is the fact that csv files are imported using a fixed number of columns: the number of columns in the source when first imported. This means that if your source csv has a column added to it, the furthest right column in the file is ignored. Not sure if this is your case, but very useful to know if you're dealing with csv sources nonetheless.

 

You can fix this so that the csv always picks up all columns in the source as follows:

 

In Power Query, go to your source step and completely delete the column value argument here:

csv source remove columns.PNG

So that it now looks like this:

csv source no columns.PNG

 

You will now always import all available columns as they are added to the source.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




amitchandak
Super User
Super User

Syndicated - Outbound

@trademobilemart, open the Edit/Transform Data query.

Right-click the open feed editor in the table. From the column list carefully remove the data-typed column.

If you change the name, rename it there.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)