Currently, a new data source is created within the Power BI service for every new Power BI report published through Power BI Desktop. A new data source is created even when the same data source from ...
In my case I have multiple reports that are all being shared with the same end user audience via the automated gateway refresh process and the Power BI cloud. I have created a star schema that allows for multiple report creation. I created multiple report tabs in a single report set. Many different reports with many different filter and data ordering options. This allows you to have multiple reports pointing to a single data set. When the users open the report they can pick the tabs that have specific interest to them. It might be MUCH more complicated if you try to use row level security in a mixed report set.
