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
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,
LydiaHi Lydia,
Bookmark Allow Users to switch between Tables Daily /Weekly/Monthly.
But, all tables need to upload to power bi in advance.
is there any possibility to choose the relevant table in query before uploading ?
Dan
Anonymous,
As my previous reply, you would need to create table parameter in Power BI Desktop.
Regards,
Lydia