Parameter unable to change when using Append Queries (multiple db sources)

[othunderx]

Hi everyone

I've design and publish a report that get data through SQL with PowerBI parameters from different db and using PowerBI Append queries combine into one table.
I got error When I try to change parameters on PowerBI Online.

Does anybody know is this an limitation on PowerBI or Have another way to solve this problem?

I need to design a report with two requirements on PowerBI.
1. Combine serval database tables (with different db connection) into one table.
2. Parameterized queries when refresh data on PowerBI Online.

I will explain my design in detail below.

I created 2 parameters, all text and required.

I connect 2 sources, one from MySQL, another from SQL Server and both have parameter in SQL.

1. MySQL

2. SQLServer

I combine 2 queries by using Append Queries as new.

The data is now combine perfectly into one Table.

After publish to PowerBI Online.
I've also setup on-permises gateway.

And data refresh is no problem.

Finally I want to change parameter and refresh on PowerBI Online.

Change parameter values

it shows error when click update button.

[v-shex-msft]

HI @othunderx,

Did this issue fixed now?

Regards,

Xiaoxin Sheng

[othunderx]

Hi Xiaoxin Sheng

I still got error when I try to update parameters.

[v-shex-msft]

HI @othunderx,

The ticket which I mentioned seems fixed, I'd like to suggest you submit a support ticket to get more support.

submit a support ticket

Regards,

Xiaoxin Sheng

[v-shex-msft]

Hi @othunderx,

Current this feature still in beta(power bi team are working on it), there are lots of users faced different issues with this feature(one of CRI 65040743), so I'd like to suggest you to wait for the recent ETA.(4/16, 4/23)

I will update here if any related feedback.

Regards,

Xiaoxin Sheng