Forum Discussion
Issues with Model when fetching data with
Hi All, I have an issue as, Unable to fetch data into report with multiple tables. RLS needs to applied on Master but when we try to bring data from Categories and Transactions in one report ...
This is not a row level security problem. You can prove this by removing all RLS and see if the data is shown. Have you debugged it in the way I suggested?
--
I can only give general advice about the model (I have no idea what your requirements are). It looks to me like the model is based on a relational database and has not been altered for dimensional modelling. So my general advice is find out what data the users want to see in visualisations, find out how they want to slice and dice that data.