The column of the table wasn't found - looking for table name
I renamed my columns in PowerBi desktop to remove the table name preceding the field names and then uploaded the dashboard to the Report Server. My scheduled refreshes are now failing and giving me this error (the table and field are just examples): 0] -1055784932: The column ‘table2021.xyz’ of the table wasn’t found.. the exception was raised by the IDbCommand interface. The field name in my report is xyz but the refresh is looking for table2021.xyz.... I have 6 dashboards that have a lot of measures that need that field to be xyz not table2021.xyz. Is there a work around that will allow me to schedule refreshes instead of updating in desktop and uploading every day? Prior to January 2021 this wasn't an issue.
