Forum Discussion
Unable to see Oracle Materialised views in Oracle Database Connection
Oooooooooooookay... well...I figured it out...
So, turns out, and I apologise because I did not know this was a thing, Power BI stores permissions globally.
E.g. the first time you connect to a data source, that's the connection schema you will connect with henceforth.
Since I had previously used schema that did not have access to those MVs OF COURSE I wouldn't be able to connect to them.
What clicked for me today was this. I tried to create a view, that pointed to the MV, using said disallowed Schema. As soon as the creation string failed, all dominoes fell, and I knew what was going on.
Sigh...well at least if anyone else has this issue they can not make the same mistake as me.
So here's how to change the global string:
File > Options and Settings > Data Source Settings > Global Permissions > Fix yo junk