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.
Any help to fix this issue is highly appreciated.
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
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?!!
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.
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.
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.