How to replace ODBC data source to dataflow?

[zakkyang]

Hi ,

When I right-click the Source in Query Editor, I found there is no option to switch to a dataflow, is it possible to switch to it?

Thanks.

[Anonymous · Accepted solution]

Hi @zakkyang,

Perhaps you can use power bi dataflow connector to get data from dataflows:

Configure and consume a dataflow - Power BI | Microsoft Docs

If you mean to change the data source on power bi service side, I'd like to suggest you take a look at the following blog to parametrized your connection string with query parameters: (you can change the parameter to update the data source host on the power bi service side)

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

Xiaoxin Sheng