Power Bi refresh report massively

[Syndicate_Admin]

Nice day

Is it possible to have several workspaces, each pointing to a different Dataset (of sql) from different servers but with a single report?

I would have the report and the dataset in each area, but I want to make changes in a single report and update it in all areas without modifying its dataset.

[Syndicate_Admin]

Perfect, do you know where I could find an example of that or a tutorial?

[parry2k]

@Syndicate_Admin yes, and you need to update the M code in the advanced editor to change the fixed value with the parameter value.

[Syndicate_Admin]

Should I add the parameters as text with the name of the server / IP?And how can I assign to that parameter with which database I want to enter?

[parry2k]

@Syndicate_Admin I don't think that is possible, the best way is to create a template file (pbit) with server connection as a parameter, and then create multiple files connecting to different datasets and publish it. You can also explore using the new pbip format, and changing the metadata to link to the new dataset and then republishing it.