Change the Source of Power BI Datasets Dynamically Using Power Query Parameters

[Anonymous]

Hi,

I need help for the Change the Source of Power BI Datasets Dynamically Using Power Query Parameters. I have created Database Parameters in power Bi see the below image and in SQLServerinstance only one server passes as Parameter.

when I select a parameter in the get data source and pass the default parameter and choose the table from that database and pull the table its works properly But I want another table from a different database so I change the database name form the edit parameter I getting below error.

Is it possible with a dynamic database parameter to change the database and pull the table from a different database?

Thanks In Advance.

 

[v-chuncz-msft]

@Anonymous 

The latest version works fine for me. Try to recreate the report.

[Anonymous]

Hi,

I tried with the latest version (September 2020)but I am getting the same error. 

.

Thanks In Advance.