Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jamesradams
Regular Visitor

Error refreshing data source when I add variable

I have a dataset in csv with 40 columns on. If I add two more columns in the middle the last tow columns are not recognised when I refresh the file.

 

How can I fix this? 

 

I see

 

Expression.Error Column "uplift_res" was not found.

 

It is definitely in the CSV.

6 REPLIES 6
jamesradams
Regular Visitor

In the end I just deleted the data connected and then connected it again. Seemed to work.

 

I don't know how to access the query code. I just click the menus. "get data - csv - file" etc.

Here is your access to the query editor:

 

Query editor.png

Specializing in Power Query Formula Language (M)
MarcelBeug
Community Champion
Community Champion

You need to verify your query code and adapt it to the new layout of your csv file.

 

E.g. some steps may included column names (or number of columns) that need to be adjusted.

Specializing in Power Query Formula Language (M)

I don't understand what you mean by verify my query code. It's a simple CSV with some columns. I've added some columns to it and want them to read in. I don't recall any issues like this is Tableau. 

Anonymous
Not applicable

Hi @jamesradams,

 

@MarcelBeugis talking about your query code in Power BI Desktop.

The thing would be if you provide us with a picture of the column names of the csv and the query code.

Probably your query code includes hard coded column names.

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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