cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
othunderx Frequent Visitor
Frequent Visitor

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

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.
parameters


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

1. MySQL
Query_MySQL
Query_MySQL_Data


2. SQLServer
Query_SQLServer
Query_SQLServer_Data


I combine 2 queries by using Append Queries as new.
Append
The data is now combine perfectly into one Table.
Append_Data


After publish to PowerBI Online.
I've also setup on-permises gateway.
on_permises_gateway
And data refresh is no problem.
refresh_history

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

online_parameters

Change parameter values

online_parameters_change

it shows error when click update button.
error

 

4 REPLIES 4
Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Community Support Team
Community Support Team

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

HI @othunderx,

 

Did this issue fixed now?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
othunderx Frequent Visitor
Frequent Visitor

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

Hi Xiaoxin Sheng

 

I still got error when I try to update parameters.

Community Support Team
Community Support Team

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

HI @othunderx,

 

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

Support Ticket.gifsubmit a support ticket

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors