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
Baskar Super Contributor
Super Contributor

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

View solution in original post

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.

View solution in original post

2 REPLIES 2
Baskar Super Contributor
Super Contributor

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

View solution in original post

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.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 767 guests
Please welcome our newest community members: