Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Import Data from Multiple Data Source and Servers

Hi All,

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 ?

 

More Info:

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 

From Date:

To Date:

 

Afterwards, the query will go to the correct server and correct  table and get the data.

 

Hope for your Answers.

 

Tks,

Dan

 

 

 

11 REPLIES 11
Greg_Deckler
Super User
Super User

Yes, you would do this via Query Parameters and then use those query parameters in your Source and/or Navigation line(s).


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi Greg,

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 !

Dan

@Anonymous,

Please review the following example.
1.PNG2.PNG3.PNG4.PNG5.PNG

Reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

pic1.JPG

pic3.jpg

 

 

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,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Anonymous,

It is only possible when you have  these tables in SQL data source and create table parameter in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I have those tables in my Data Base.

It will be great to receive your help or recommendation for it.

 

Lydia, Tks A lot !

 

Dan 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors