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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors