Multiple reports with same data set - Get overwritten once republished

[mchacha]

Hi,

To give some background, I'm pretty new to PowerBI but fully interested in improving mylsef, so I might not know some basic basic stuff.

I made a report and published it, with this report I wanted senior management to be able to see some tabs and some other users to see the remaining tabs. I wanted to avoid duplicating my powerbi and to keep one same dataset so I created a copy of the published report and edit the tabs I wanted. 

However, as it is still under draft, when I need to modify some things in PowerQuery and I need to republish it to PowerBI, it overwrites the two duplicated reports and comes back to the original view. I don't know if I'm clear... 

I'm not sure how to avoid that or what would be the best solution (in the end, would it be better to duplicate my powerbi? but then if I need to amend a powerquery I need to do it in both...). 

My goal would be with the same powerbi, create multiple reports with specific tabs accessible to different users. I already created Row level security but it's for my filters, not tabs.

Thank you for your help!

[SaiTejaTalasila · Accepted solution]

Hi,

You can build multiple reports on a single semantic model.Please refer this -

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

I hope it will help you.

Thanks,

Sai Teja 

[mchacha]

Hi,

Thanks for your reply. I tried to do a test and from a copy of my pbix, do "Get data -> Semantic model" but I have a popup that says my admin doesn't le me. 

Should I ask access or there is a way to bypass it? Then I'm wondering (might be a dumb question), if I republish this report by connecting through semantic model, will it republish the semantic model as well in the workspace (and then still have two) ? 

[mchacha]

Hi,

Thanks for your reply! 

I had a training and it was shared to use the same semantic model for several reports as a "best practice", but in the end I shouldn't ? I found it a bit counter productive to duplicate the pbix and republish it, because I'll have two semantic models then so it must run twice - what do you think ? 

Thank you!

Marie

[v-xuxinyi-msft]

Hi @mchacha 

After my testing, I came to the conclusion that it's because your two reports share a semantic model, and the changes you made in PQ are reflected in the semantic model, so it's affecting both reports.

I'm afraid you need to copy the pbix directly and then publish the two reports to the service separately so they have two semantic models and won't affect each other.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.