Data Source Error - The column does not exist in the rowset

[smjzahid]

I have report which has 40 different tables pulling data from multiple sources, Its now throwing below shown error in Power Bi Service.

Is there a way in PBI Desktop to get to the error column, since the error do not point to the table or column name, it gets really difficult to get to the bottom of the error, 

any tips and tricks to find out the cause is really appreciated

[v-jayw-msft]

Hi @smjzahid ,

This error might be caused when a column was removed or renamed in the original data source.

Check your data for the above conditions. Then try to clear Power BI Desktop cache and click the refresh button to check if the error still exist.

Best Regards,

Jay

[amitchandak]

@smjzahid , Try download the error log in service if any, and check

try to refresh on dashboard and check any table that error out