Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.