Forum Discussion

steen_p's avatar
steen_p
Icon for Helper II rankHelper II
6 years ago
Solved

Select columns to load from SQL Server

Hi, I have now used Power Query for quite some time, to load data into Power BI models as well as SSAS Tabular Models. I have one annoying issue, that I haven't found a good solution for, and that'...
General Comment
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi steen_p 

     

    Why not select the column you want to keep and use right-click option to "Remove other columns", or go to  Home > Choose Columns and select your columns there?

     

    This will list the columns that you want to keep and not the ones that you don't need.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi steen_p 

 

Why not select the column you want to keep and use right-click option to "Remove other columns", or go to  Home > Choose Columns and select your columns there?

 

This will list the columns that you want to keep and not the ones that you don't need.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • steen_p's avatar
    steen_p
    Icon for Helper II rankHelper II
    6 years ago

    Hi Mariusz,

     

    Thanks for the answer. I don't think I've ever thought about that was the way to do it ðŸ¤”. Maybe it's because we (so far) do all the table and column work in our Datawarehouse, so we never really use any of the tble "manipulation" options in Power Query. But it seems like it''s doing what we are looking for - in a little ackward way in my opinion though, but that's just how it is.

     

    Thanks :-).

     

    Regards

    Steen