Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

what is the best approach if i need to create multiple reports on same dataset in power bi

Hi All,


I have a requirement where we need to create 10+  Power BI reports from same tables, Datasource we are connecting is snowflake.


Can anyone help what is the best approach to create the reports. currently approach we are following is importing the tables from snowflake and publishing all 10 reports into the workspace. 



Our workspace is premium capacity

Super User
Super User


If you build a single dataset without any visuals and publish it to the service you can then delete the empty report part and be left with the dataset. You can then connect to that dataset in power bi desktop and create "thin" reports that all use the single dataset.


If the reports already exist... 

1) Save backup copies.

2) In transform queries delete all the tables.

3) Delete any calcualted tables (Check for any hidden tables).

This will look like it's broken anything but if you then go get data... from power bi dataset you can connect it and it will all work.


There are many ways of going further than this. We have a Models workspace which has our enterprise model(s) in and reports are then in other workspaces. As long as people are given read permissions on the dataset they don't need to be viewers or members of the model workspace it self. You can also grant build permissions to the dataset.


Finally since you have premium you can also build your initial model in power bi, publish it but then edit it within the service by connecting to it via XLMA endpoint with tabular editor (2 or 3). We use deployment pipelines so we can develop within the service without risking the production dataset. 


If any of that is of interest I'm happy to go into more detail.

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.