Forum Discussion
Import Data from Multiple Data Source and Servers
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,
Lydia
Anonymous,
As my previous reply, you would need to create table parameter 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,
It is only possible when you have these tables in SQL data source and create table parameter in Power BI Desktop.
Regards,
LydiaI have those tables in my Data Base.
It will be great to receive your help or recommendation for it.
Lydia, Tks A lot !
Dan