cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nagaraja Frequent Visitor
Frequent Visitor

Querying the Database

Hi everyone,

 

I'm new to Power BI,

Can anyone please tell me If I'm trying to pull the data connecting to any database, say MS sql server, am I extracting all the data into Power BI and execute the query so as to pull the required data (Which I think not) or am I only extracting the required data after querying, into Power BI.

 

Let's say the server has 2GB of data and the required data out of it is just 100MB,

Now am I Extracting the whole 2GB data into Power BI so as to execute the query.

 

 

Like I said I'm pretty new to Power BI so Please don't mind if it is really silly.

 

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Querying the Database

Cool Dude,

 

Yep we can do in both ways in Database end as well as Power BI data modelling using Power Query.

 

The Best way is u could restrict the data in Database ,

it will give u best performance and

Reduce the file size as well.

 

let me know if any help

Moderator v-yuezhe-msft
Moderator

Re: Querying the Database

Hi @Nagaraja,

You can write T-SQL statements in the following textbox to extract specific data from SQL Server database and import these data to Power BI Desktop, it will improve performance for your current Power BI Desktop file .

1.PNG


Thanks,
Lydia Zhang

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.
2 REPLIES 2
Super User
Super User

Re: Querying the Database

Cool Dude,

 

Yep we can do in both ways in Database end as well as Power BI data modelling using Power Query.

 

The Best way is u could restrict the data in Database ,

it will give u best performance and

Reduce the file size as well.

 

let me know if any help

Moderator v-yuezhe-msft
Moderator

Re: Querying the Database

Hi @Nagaraja,

You can write T-SQL statements in the following textbox to extract specific data from SQL Server database and import these data to Power BI Desktop, it will improve performance for your current Power BI Desktop file .

1.PNG


Thanks,
Lydia Zhang

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.