cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manjula
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

1 REPLY 1
bcdobbs
Super User
Super User

Hi,

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

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors