Same report with diferent dataset's

[Marrafeiro]

Hi everyone,

I'm have a big question.
I made a project in university for an enterprise, where i have a PWA where i show Power Bi reports. Now the enterprise want i change the application, where users can login, but every user see diferente data from diferente Data Bases. That Data Bases are in the same server.

So i need with just 1 report i can connect to diferents DataSets.

I'm already capable to show reports with Power Bi API. But i do not find anything about this.

What can i do?

Thank you.

[Greg_Deckler]

You want it all in a single dataset and use RLS.

[Marrafeiro]

I can't, that is 140 databases with around 60 tables. all with diferent data.