Azure sql server datasource changes(Dev server to Production server) in Power Bi service

[Anonymous]

HI Please help how to change datasource Dev server to Production server

My Database:Azure sql server(Both servers)

My Connection mode:Direct querys and Import (few reports Direct query and Few Report Import method)

please help me How change my datasource

Note:I need how change in Power BI service.

Thanks

Shanvitha

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

According to my knowledge, It is not available to change data source in power bi service.

You need to change it in power bi desktop.

Or you could try to use paramter to change the datasource in power bi service

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

Notice: you should confirm these data sources has same data structure, current query table not support dynamic table structure.

Regards,

Lin