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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.