Mass report creation from different tables/sources

[AlexandraSz]

Hello!

I feel like there might be no solution for this, but as a last resort I am reaching out here.

Let's say I have data in 50 different tables. I want to create in Power Bi something like an "explorer" app, so that users can simply see each of these 50 tables in separate reports, in a in a simple table visual with a few slicers.

Not at all complicated, but I need to do this 50 times, as most columns are not repeated/have different names, and changing the data source of the report would ruin my dashboard aynway.

At this point the only thing I can do is to start from scratch for each of the 50 tables/reports.

Are there any workarounds or template functionalities I can use to make my life easier?

Thank you!

[DataVitalizer]

Hi @AlexandraSz 

Do your tables have the same structure in term of columns' names and data format?

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated

[AlexandraSz]

No, unfortunately not.

[DataVitalizer]

The current solution that pops up into my mind is creating one page with the desired design, then duplicate the page as many tables as you have, and add a bookmark through a dropdown to navigate between pages.

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos ? would be appreciated