# Supabase collection - no advanced mode possible?
**URL:** https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526
**Category:** Ask us anything
**Tags:** supabase
**Created:** [January 23, 2025, 8:18am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526 "2025-01-23T08:18:26Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@julian](https://community.weweb.io/u/julian)
#### Post date: [January 23, 2025, 8:18am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/1 "2025-01-23T08:18:26Z")
When setting up a new collection, I want the collection to contain data from two tables. So I was trying to use the advanced mode to join the tables (as explained [https://docs.weweb.io/plugins/data-sources/supabase-data.html#advanced-mode](https://here)) (RLS is right now set up for testing so that every authenticated user could do anything). However, as soon as I click “Advanced” the option disappears and I cannot select “Guided” mode any more (so no selection of columns possible). Why is that? How to fix this?
Before clicking “Advanced”
After clicking “Advanced”
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 23, 2025, 8:20am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/2 "2025-01-23T08:20:23Z")
It’s a bug, just re-create the collection. I haven’t found a way to reproduce this, but it’s a bug. It works after a few tries.
---
### Author:  [@julian](https://community.weweb.io/u/julian)
#### Post date: [January 23, 2025, 8:24am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/3 "2025-01-23T08:24:56Z")
Hhm, are you sure? I’m having this problem for quite a long time already with every collection that I try to set up in Advanced mode. I tried it just now 7 times - and it does not change anything. If it’s a bug, there should still be some logic behind and not only work randomly, I guess.
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 23, 2025, 8:36am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/4 "2025-01-23T08:36:43Z")
---
### Author:  [@julian](https://community.weweb.io/u/julian)
#### Post date: [January 23, 2025, 8:40am UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/5 "2025-01-23T08:40:00Z")
Thanks a lot @Broberto, it’s a very weird issue then!
---
### Author:  [@dttdd21](https://community.weweb.io/u/dttdd21)
#### Post date: [August 3, 2025, 6:07pm UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/6 "2025-08-03T18:07:50Z")
Hey everyone,
I encounter now the same issue. How to get it solved?
Console error in browser (no extensions running):
index-BwqjUYKk.js:15 TypeError: Cannot read properties of undefined (reading ‘user\_profiles’)
at Proxy.isRealtime (manager.js?v=1:1:3294)
at hMe (index-BwqjUYKk.js:11:3260)
at get value (index-BwqjUYKk.js:11:15297)
at Object.get [as isRealtime] (index-BwqjUYKk.js:16:12816)
at Object.get (index-BwqjUYKk.js:16:10272)
at Proxy.isPrimaryRequired (manager.js?v=1:1:3919)
at hMe (index-BwqjUYKk.js:11:3260)
at get value (index-BwqjUYKk.js:11:15297)
at Object.get [as isPrimaryRequired] (index-BwqjUYKk.js:16:12816)
at manager.js?v=1:1:6580
Later edit: seems to be connected to the realtime functionality. If enabled, everything works like in the documentation
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [August 3, 2025, 10:44pm UTC](https://community.weweb.io/t/supabase-collection-no-advanced-mode-possible/15526/7 "2025-08-03T22:44:59Z")
Realtime doesn’t work with Advanced (joins)