Forum Discussion

kdkimble's avatar
kdkimble
Frequent Visitor
9 years ago
Solved

Pre-Filtering Data before Importing

I have a table in a SQL Server and I want to filter before bringing into Power BI Desktop.  The reason is that I need uinque information in order to joing to another table.  Currently whey i try to m...
Need Help
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    you could also write a sql native query to filter data out (which is the same as a view but you dont have to create a view) which you can paste in the advanced section when you do a get data

     

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

you could also write a sql native query to filter data out (which is the same as a view but you dont have to create a view) which you can paste in the advanced section when you do a get data

 

 

  • kdkimble's avatar
    kdkimble
    Frequent Visitor
    9 years ago

    Thanks for the suggestion.  Appreciate it.