Forum Discussion
Import Data from Multiple Data Source and Servers
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
Hi Lydia,
Tks for your respond.
But it's not what I meant.
Let me clarify.
When client will open Power BI the next follows will appear:
1.Choose Country: USA \ GERMANY
2.Choose Report Type: Daily\Weekly\Monthly
3.From Date:
4.To Date:
Afterwards,
According to those parameters the query will act - Go to server and relevant table.
All the process of choosing server and table will be Behind the Scenes
(server name and table name don't show in any stage of the process)
see the next simlar example in picture:
in this example I create SQL Procedure which received User Name, Password and dates and get the data.
(in this case data are imported from only one server and one table.
therefore it's not create trhe flexibility as I expect.
I as sumewe should use Dummy Variables In SQL Statement (see in picture)
and use M Query as you mentioned.
Hope For respond.
Tks,
Dan
Anonymous,
It seems that you want to use parameter in the SQL stored procedure. If so, please take a look at the following blog and similar thread.
https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/
https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/td-p/57734
Regards,
LydiaHi Lydia,
I read the articles you added.
This articles not answer on the next question:
How can I switch between servers and tables Behind the Scenes according Client Details ?
For Example:
When Client choose country USA the query should return USA Server address (Behind the Scenes)
When Client choose Country Germany the query should return Germany Server address (Behind the Scenes)
In addition:
When client choose daily report the query should return daily table (Behind the Scenes)
when client choose weekly report the query should return weekly table (Behind the Scenes)Hope for respond
Tks A lot !
Dan
Anonymous,
What you describe can't be achieved in Power BI. You would need to create explicit server parameters for users to choose.
For daily/weekly report requirement, a method is to use bookmark feature in Power BI Desktop.
Regards,
Lydia