Import special columns from SQL Database

[Nick001]

Hello, everyone,

I am again in the process of improving my data model and this time it is the import from a SQL server. I am currently loading the entire table from the server into PowerBi, and I only need two columns from the table. Is there a possibility, instead of using select *, to go to the two columns directly?

And 2nd question, could the list be restricted to certain import parameters? for example on the date?

many thanks and best regards Nick!

[mussaenda]

Hi @Nick001 ,

you can work on using SQL statement as what @V-pazhen-msft stated.

Like

select

[column1],

[column2]

from

[dbname].[dbo].[tablename]

where

[date] filter/parameter goes here

--------------

hope this helps

[V-pazhen-msft · Accepted solution]

@Nick001 

And for Q1, you can only connect to the db table first, then use sql statement or remove others column  in power bi to get the 2 columns only.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

Value.NativeQuery() does the trick in your scenario; it works with intact SQL supported by your database.