Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm assisting a client with some development and want to know how the following can be done:
They have a Web App that will be deployed on different Azure data centers for different clients.
Each deployment of the Web App will connect to it's own Azure SQL database.
They want to create PowerBI reports and embed them in the Web App.
How can the multiple instances of the Web App load the same report but change the data source to load the data from the applicable Azure database?
Solved! Go to Solution.
@jjrvdw wrote:
I'm assisting a client with some development and want to know how the following can be done:
They have a Web App that will be deployed on different Azure data centers for different clients.
Each deployment of the Web App will connect to it's own Azure SQL database.
They want to create PowerBI reports and embed them in the Web App.
How can the multiple instances of the Web App load the same report but change the data source to load the data from the applicable Azure database?
Those different Azure SQL database shall have the same tables consumed in the "same report". You can
@jjrvdw wrote:
I'm assisting a client with some development and want to know how the following can be done:
They have a Web App that will be deployed on different Azure data centers for different clients.
Each deployment of the Web App will connect to it's own Azure SQL database.
They want to create PowerBI reports and embed them in the Web App.
How can the multiple instances of the Web App load the same report but change the data source to load the data from the applicable Azure database?
Those different Azure SQL database shall have the same tables consumed in the "same report". You can
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
10 | |
4 | |
3 | |
2 | |
2 |