Forum Discussion
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_DecklerCommunity Champion
Yes, you would do this via Query Parameters and then use those query parameters in your Source and/or Navigation line(s).
- AnonymousNot applicable
Hi Greg,
Good to hear :)
Can you recommend me on books/blogs/youtube or
any other data source to get practical knowledge to solve this issue ?
I know how to use parameters and SQL Procedure.
However, I don't have all the knowledge how to deal with that.
hope for respond.
tks a lot !
Dan
- AnonymousNot applicable
Anonymous,
Please review the following example.
Reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Lydia