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 ?
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
Afterwards, the query will go to the correct server and correct table and get the data.
Hope for your Answers.
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 !
Please review the following example.
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
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.
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.
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 ?
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)
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 !
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.
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 ?
It is only possible when you have these tables in SQL data source and create table parameter in Power BI Desktop.
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Exciting news: We've given our badges an overhaul and added brand news ones.
Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.
Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.