You may run into the error "Query 'x' references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

If this happens, open PowerBI's PowerQuery by pressing the "Transform Data" button.

Click the dropdown under "Refresh Preview" and select "Refresh All"

You don't need to wait until the queries are refreshed, you can immediately click "Close and Apply".