Some refresh failures aren't about the data at all. Power Query protects data from one source being sent to another, and it needs valid credentials for each source.
Formula.Firewall: Query 'Billing' (step 'Merged') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. This appears when one step both reads a source and uses another query. Give each source its own staging query and combine those queries in a separate query.
Privacy levels tell Power Query how much it may share between sources: Public for open data such as a published exchange-rate API, Organizational for internal systems people in the company can see, and Private for confidential data such as salaries. Power Query won't send Private data to another source, for example inside a web query string. Ignore the Privacy Levels can speed things up, but it lets data travel between sources, so keep it for files and systems you trust completely.
Credentials expire. After a password change the refresh fails with an authentication error. Fix it in Data > Get Data > Data Source Settings: select the source, Edit Permissions, then edit the credentials.
Each source has its own query, and the query that combines them only references other queries.