Forum Discussion
Renamed columns causing error
Hi, We have a report the is pulled from SalesForce. One column in this report was previously named "Sales Rep." last week, we changed the wording to "Sales Representative" (only renamed it, did...
Based on your screenshot, the error occurs in Power BI Desktop. Do you create report in Power BI Desktop and publish the report to Power BI Service? If so, in Query Editor of Power BI Desktop, look into “APPLIED STEPS”, some steps should make changes/calculation on the ‘Sales Rep’ column(e.g. Change Type), you should delete such steps to solve the issue.
However, if you directly connect to SalesForce in Power BI Service, when you have schema changes(e.g. rename column) in the data source, you will receive the error like “The column ‘Sales Rep’ of the table wasn’t found”. You would need to remove the dataset in Power BI Service and re-connect to SalesForce.
Regards,
Lydia