Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Sudharsanan
Helper III
Helper III

Loading selected data in power query/BI

Hello Folks,

 

I am trying to load  few rows from the large data using power Query. for example the file have 1000 rows and i need to load only the rows with certain keyword from a clolum. So is it possible to filter the data before reaching the power query editor? or is there an

3 REPLIES 3
BITomS
Resolver III
Resolver III

Hi @Sudharsanan,

 

The simple answer is yes.

 

It may help if you specify what type of database your source data is coming from, but for example, with a SQL server connection: You (or your database administrator, if this is not you) can create a view in your source database using a WHERE clause to only bring in row data based on the keyword in the column.

 

Alternatively, if you do not have the access to create this view, you can write this query yourself in Power Query. When you select 'New Source' you can write the SQL statement under advanced options, but you will have to know the DB server name:

OEMTomS_0-1658409494946.png

 

The principle is the same for other types of databases and there is even a 'blank query' option under 'New Source' which may allow you to achieve what you need.

 

Having said this, 1000 rows is not a very large amount of data, so Power Query should be fairly adept at handling this through an applied filter step.

 

Hope this helps.

Thank you @BITomS for your promt response

 

Actuall my source is in actual desktop where other application drops the file with month Name for everymonth. so i wanted my query to be updated based on the month dynamically. for example, if the file is placed for Aug 2022, my file should get refreshed without any manual changes on the source.

 

hope this gives better understanding:)

@Sudharsanan - yes, this sounds like a completely different issue to the original post!

 

For the problem in your response, you can use the connection from 'Get Data' > 'More' > 'File' > 'Folder' and enter the folder path. You must ensure the folder location contains only the files you need and that they have aligned formatting. This article may help: https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query...

 

Edit: I just re-read your response and it sounds like you are just focused on a single file being stored in the same location - in this case, you can filter the table based on the file created date using the Date/Time filter: Is Latest.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors