Forum Discussion
Import Data from Multiple Data Source and Servers
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,
Lydia
Hi 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