(Cross-posted from StackOverflow)
More specifically, we have a rather large (in content) Power BI workspace that we are keeping updated on a daily basis by manually appending to a CSV (still working out details of connecting directly to SQL Server).
As of this point, we have added ~20 different tabs dissecting the resulting data. Our process right now is to publish the entire report to the master workspace > Save As > delete tabs one-by-one > publish a partially redacted version to another workspace > delete more tabs > publish further redacted version > continue loop as needed.
Compounding the awkwardness is that the master report has grown to a level where it is difficult for executive-level users to quickly find the things that matter to them, and the print-to-powerpoint option no longer works (>15 tabs). We are aware of the dashboard functionality but in practice it does not function as well as the main reports (no ability to drill down, export, etc), nor can they be published directly to Teams. Would like to work out a better way to push the data out once it is updated without the need to keep more than one .pbix. powerbi organization
