Is it possible to change a datasource type with parameters?

[Sapphire]

Hello,

I saw that by using parameters it was possible to update the server and database name, simplifying the change of a datasource for a specific report. I was wondering though, are there limitations to it documented somewhere? Or it is possible to use the parameters to connect either to a SQl server instance and oracle instance as well, and other datasources types?

Regards

[v-yiruan-msft · Accepted solution]

Hi @Sapphire ,

Please refer the solution in the following thread and check whether it can help achieve your requirement.

Dynamic Data Source based on parameter

Best Regards