Can use same report load data from different datasource using gateway

Hi All,

I have fixed this issue and below are the steps i followed.

I created one report in Power bi Desktop and used some datasource to load the report.

Once i published this report in power bi service, I go to this report dataset and click on schedule refresh icon.

There you can see the Gateway connection, Expand it.

Before doing this step you should have installed the data gateway redistributable file in the server where you can able to connect the database and assigned some member to access the data gateway.

After expanding Gateway connection, Can see the data gateway name is present there. Click on manage getway and add new datasource and configure your database with DB server credentials. Once done then you can select the specific datasource to this report.

Now for the second time for the same report open in Power bi Desktop then change the datasource and use the another datasource to load the report. Once done then publish it to the Power bi service under specific worksapce.Now do the same activity as shown above. Create new datasource in gateway connection and assign that datasource to this report.

Using above steps we can able to reuse the same report with different datasource.

Thank you.