Forum Discussion

othunderx's avatar
othunderx
Frequent Visitor
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI othunderx,

     

    Did this issue fixed now?

     

    Regards,

    Xiaoxin Sheng

    • othunderx's avatar
      othunderx
      Frequent Visitor

      Hi Xiaoxin Sheng

       

      I still got error when I try to update parameters.

      • Anonymous's avatar
        Anonymous
        Not applicable

        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