One report (PBIX) For Different client and different SQL server connection

[mukund]

Hello,

I have multiple clients (Web applications) pointing to different SQL server database (same schema).

I have created a power bi report (PBIX) and I am embeding it to my web application through REST API.

Is it possible to get report from same PBIX for different clients from their respective database data?

for example if I make a call using REST API from client1 I get that client1's database data and if I make a call from client2 I get that client2's database data displayed on report.

[v-alq-msft · Accepted solution]

Hi, @mukund 

Unfortunately, it is unavailable to achieve your requirement. You need to create multiple pbix files. Each pbix file is created for a corresponding client.

Best Regards

Allan

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