Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have to create about 100 reports which are pretty much identical but they will be published on our site. The only difference being each report is for a different city that is stored in our database. Right now I plan on creating, publishing and sharing 100 reports but that is not a scalabble model as if I need to change anything I now have to go back and edit all the 100 reports.
Is there a better way where I create one report that I send a specific variable (city in my case) to and it will create that report?
I can't use role based views as this is for folks outside my organization.
Nishant
Hi @Nishantp
There has been a recent change where you can now share content outside your organization with Power BI and Business to Business.
This would allow you to create one report and then share it to the relevant users using Row Level Security.
This would be the only way I would implement it, because to try and maintain 100 reports would be extremely time consuming, as well as prone to error via all the different reports.