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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
trevb
Resolver I
Resolver I

One Dataset multiple reports

I have a report that I created that is used by three different types of users.  It does however use exactly the same dataset underneath.

 

Is there a way to create multiple reports that all use the same dataset?  Currently the dataset seems to get named after the PBIX file so if you have three versions you get three datasets.  My current solution is to have one report that contains all the elements that is my working solution.  I then load that report delete the tabs that are not necessary for a particular userbase then save and publish for that user base.

 

This is a bit of a pain and if I forget to do one I risk the data being inconsistent.  This is escalating as more groups need specialised versions of this based on the same data (bearing in mind much of that data is created in power queries from the original source database).  Really what I'm trying to do here is make sure that all related reports are using the same version of the power queries.

 

Does anyone have any thoughts on how this can be managed?  Is it just that the complexity around this has not been addressed yet or is it that I am missing an obvious solution?  If I could even publish one report and hide tabs based on the logged on user I could live with it.  Any suggestions gratefully received.

1 ACCEPTED SOLUTION
Habib
Responsive Resident
Responsive Resident

Power BI Templates can be a choice in this case. You can get details regarding this on below link.

 

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

 

 

View solution in original post

8 REPLIES 8
IanCockcroft
Post Patron
Post Patron

JDSX
Frequent Visitor

Hi,

 

As I understand it, templates are a snapshot as of the instantiation in a particular report. What if I want to modify the dataset on which 30 reports rely? Do I have to choose 1 of the pbix, make and publish changes, export to overwrite existing template, then export to pbix each of the other 29 reports from the cloud?

I think this new feature (preview yet) that allows one to connect to published datasets may solve it better:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-lifecycle-datasets/

Rémi
Resolver III
Resolver III

Hi,

 

Did you try to publish your dataset and then do multiple report into the web version version with the same dataset ?

When you edit a report int othe web version, you can do "Save as". It will create a new report with same data. This report must be edited with Power BI service.

If you update your data, all related report will be updated. Same thing if you update your dataset with new columns/queries/tables or other elements that you can add from Power BI Desktop.

 

 

Hello,

is there a way to modify the "second" report in Power BI Desktop or do can I use PBServices only?

The desktop version is much easiermore friendly!

 

Thanks

Elena

I get it you mean do the final Tab adjustments in the web version and then save those.  Interesting thought too.

 

Many thanks both some good ideas to try there  🙂

 

Habib
Responsive Resident
Responsive Resident

Power BI Templates can be a choice in this case. You can get details regarding this on below link.

 

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

 

 

Ta Habib I will have a look at this see what it can do for me.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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