Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import Data from Multiple Data Source and Servers

Hi All,

I need to make a Dashboard,

which Import Data from only one Server (from 2 servers) and only one Table (from 3 tables)
On Demand (Create by QUERY and Parameters).

 

I need to know :
1. Is there any possibility to make Query which allow User to choose server and Table by Query and Parameters ?

 

More Info:

I Have 2 servers USA & GERMANY

In addition I have 3 Tables Types: Daily, Weekly, Monthly per each server  (All Data Aggregate by Each Period Type)

 

when client open Power BI Report he will see the follows: (UI)

Choose Country: USA \ GERMANY

Choose Report Type: Daily\Weekly\Monthly 

From Date:

To Date:

 

Afterwards, the query will go to the correct server and correct  table and get the data.

 

Hope for your Answers.

 

Tks,

Dan

 

 

 

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Yes, you would do this via Query Parameters and then use those query parameters in your Source and/or Navigation line(s).