How to troubleshoot Power BI data refresh failures

When a Power BI refresh fails, don't just look at the last line of the error message; often, the root cause lies in data source permissions or changed field types. I first manually refresh in Desktop to see which table breaks first, then check the server to see if the gateway is online and if credentials have expired. If SQL queries were recently modified, I focus on date fields, null values…