Forum Discussion
Expression.Error Column of table not found
Hello, I'm using Power BI Desktop to pull in a bunch of .csv files from Sharepoint and then using a Sample File to help arrange the data. When trying to refresh all data, i'm getting the followi...
Hi WillBrowne
It could be a step where you renamed or re-ordered columns, changed data types, removed other columns, replaced values.
You could try the methods suggested by members here.
As tested on my side, if i remove the "Columns=55," from the following code, it could refresh successfully.
Source = Csv.Document(Parameter2,[Delimiter=" ", Columns=55, Encoding=1252, QuoteStyle=QuoteStyle.None]),
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.