Refresh Dataset Failing from Web Only

[SA_]

We are getting errors when refreshing from web - but not when we refresh our report on desktop and push manually. We know this isn't a credential issue either. The error states the specific column was not found, but we confirmed this wasn't the case looking at our data - and also didn't happen on the desktop report. Any ideas as to what is causing this? 

Processing error: The column 'request_status' of the table wasn't found.
Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID: 2fce80b1-e042-494f-99bb-ed6b027dbc13
Request ID: da44e119-bba7-fccc-5bac-1904fcd08d89
Time: 2022-05-04 16:38:14Z

[Anonymous · Accepted solution]

Hi  @SA_ ,

According to the error message, you might have some steps that reference the column ' request_status' 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

This is the related document, you can view this content:

https://www.youtube.com/watch?v=LAfiN6cp2T8

https://answers.microsoft.com/en-us/msoffice/forum/all/expressionerror-column-of-the-table-not-found...

https://www.antaresanalytics.net/post/2018/08/13/data-management-m-scripting-preventing-the-column-o...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StefanoGrimaldi]

can you share the query and the credential setting you have on the service web for this model? it could be that you havent set up the credential on the dataset source credential section or isnt set up correctly i the gateway you using for it,