Works without Blend, Not working With Blend

Hi Community, I am very new to Dashboarding, I am running into a weird issue where I have 3 data sources all on Google Sheets that I can connect to charts and they work great - as intended, But I have a requirement where the data from these 3 sheets need to be shown on the same page and be able to filter by the same control. I figured out that you need a blend to do those and have all charts on that page and the control be connected to the blend.

My issue is when I go ahead and blend the 3 data sources together I get this error
"The underlying data has changed. Please notify the data source owner to refresh." Error ID: a2ff4a53

I can't seem to figure out what I did wrong? Can someone else point me in the right direction. I need to show this dashboard in less than 12 Hrs 😵

LitroWorkflow_0-1732806728021.png

If it is of any significance they all have a common field called `Distributor` which I use to do the joins.

LitroWorkflow_1-1732806827342.png

the last 2 tables are actually the same data source but I couldn't get all the dimensions so I have to connect it again and grab the rest (Tried it with the same data source inside Looker Studio as well as connecting the Google Sheet twice as 2 different data sources - Both had same results). 

 

Thanks in Advance for any help, you will be a life saver 🙏