I have a Power BI dataset that connects (imported mode) to SQL Server. It is a fairly compex model, loosely based on a star schema, but with 3 fact tables and about 60 dimensions. I've configured scheduled refresh and a complex row level security model on it, and it serves its purpose. Some use cases have appeared however where users only need to connect to a subset of the model (e.g., 1 fact table and 10 dimension tables).
My plan was to create a new Power BI Desktop report, connect to existing published Power BI Dataset containing the large model, then start deleting/hiding tables that aren't needed (from the fields pane on the right hand side of PBI Desktop, where these options normally are). Unfortunately, these options aren't available (I believe this must be because I'm connecting to a Power BI dataset).
How else can I achieve what I want? I don't want to go back to my SQL Server data and create a fresh report, because then I would need to duplicate my security model. I want to connect to my existing Power BI dataset and then start removing entities to simplify things for my end users who only need to see a subset of the model.
