cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
v-sadadi Regular Visitor
Regular Visitor

Expression.Error: The column '' of the table wasn't found.

Hi Team,

 

I have a pbix file connecting to CRM online source. I have recently made an update to one of the query by adding new fields to the query from the available CRM fiels in desktop file. But getting the below error when I refresh the query.

 

Error.jpg

 

Any help to fix this issue is highly appreciated.

 

Thanks

Satya

 

 

8 REPLIES 8
Community Support Team
Community Support Team

Re: Expression.Error: The column '' of the table wasn't found.

Hi @v-sadadi,

 

According to the error message, you might have some steps that reference the column 'newlsLifecycleProposalincludedfromOSE' which has been removed or renamed or any other operation when you modified the query. It could be a step where you renamed, re-ordered columns, changed data types, removed other columns, etc.

 

Directly, right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it. 

 

Here is a similar thread as yours, please take a reference:
Expression.Error: The column '<ColumnTitle>' of the table wasn't found

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
joan990 Visitor
Visitor

Re: Expression.Error: The column '' of the table wasn't found.

Hi @v-yulgu-msft,

I have the same problem, I am getting my data by API from Freshservices. So when I call overdue tickets and the result is 0 I am getting this error because no data are available and that affects on all the report and can't be refresh.

any solution for that?!!

 

Capture.PNG

SurendraP Frequent Visitor
Frequent Visitor

Re: Expression.Error: The column '' of the table wasn't found.

Problem resolved for me by removing the columns from Advanced Editor. Thank you, 

sampam Regular Visitor
Regular Visitor

Re: Expression.Error: The column '' of the table wasn't found.

I had a similar error... edited the M code through Advanced Editor. That resolved it. thanks

rhartop Frequent Visitor
Frequent Visitor

Re: Expression.Error: The column '' of the table wasn't found.

I get a similar error though in Power Query the table loads successfully. It is only when the data set gets pulled into Power BI desktop after clicking 'Close and apply' in the Power Query editor that the full load says that column was not found. This is particularly frustrating as it is not possible to see at what stage the error is getting thrown at in Power Query because confusingly Power Query is able to refresh the dataset.

Akash-Shedge Frequent Visitor
Frequent Visitor

Re: Expression.Error: The column '' of the table wasn't found.

Hi,

 

What operation do you perform in advance editor?

I am Trying to Connect it with google sheet.

1st-time data got loaded but when I refresh it the error occurred.

 

Thanks. 

 

 

sampam Regular Visitor
Regular Visitor

Re: Expression.Error: The column '' of the table wasn't found.

Open the advanced editor and remove the column from the code.. be sure to copy the original code first incase something goes wrong.

34911995 Visitor
Visitor

Re: Expression.Error: The column '' of the table wasn't found.

Refresh each table individually.

Click on the ellipses (...) on the Data or Report view for each data table then "Refresh data".

Once you have done that you may Refresh the whole Power BI.

Alternatively, you may load each table individually and one table refreshes each time you upload a time.

 

That should assist.