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 😵
If it is of any significance they all have a common field called `Distributor` which I use to do the joins.
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 🙏