My team has a few hundred reports, the vast majority of which connect via ODBC to a Cloudera Hadoop database. We are migrating everything to Azure Synapse Analytics, and all reports will need to be updated accordingly. Obviously this is no small undertaking. I'm looking for guidance on any specific do's and don't's that others may have encountered.
I have found a few times that Power BI doesn't seem to do a great job of looking for solutions or giving you specific errors about what's missing. So if a column name were to change, it just says "that's no good" instead of "can't find column first_name".
If there's a systematic way to do this I'd love to learn more about it.