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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
juanito
Frequent Visitor

Steps order to download file already filtered to Power BI

Hi everyone,

I have a doubt about the exact order of the steps that Power Bi executes when downloading any file to Power BI Desktop.

For example here my script:

 

let

#"Source" = Table.SelectRows(Csv.Document(File.Contents("File path"),[Delimiter=";", Columns=22, Encoding=1252, QuoteStyle=QuoteStyle.None]), each ([Column1] > "30"))

in

#"Source"

 

When I execute this script, does it first download all the file and then do the select or does he filter before downloading the file (downlading the file already filtered)?

I am asking this because I have a very large file that I would like to filter during the download (I don't need everything). Assuming that I can't modify the file so I have to do it with Power BI. I need to download it already filtered.

 

Thanks in advance

1 ACCEPTED SOLUTION

@juanito

 

Yes, please refer to the screenshot below.

 

Steps order to download file already filtered to Power BI_1.jpg

 

Best Regards,
Herbert

View solution in original post

3 REPLIES 3
v-haibl-msft
Employee
Employee

@juanito

 

All downloaded file should can be seen in Query Editor. With your script, we can only see the filtered data after import, and there is only one step in the right pane. So it should do the filter before downloading the file.

 

Steps order to download file already filtered to Power BI_1.jpg

 

Best Regards,
Herbert

Even if, like in this case, the source is OData?

@juanito

 

Yes, please refer to the screenshot below.

 

Steps order to download file already filtered to Power BI_1.jpg

 

Best Regards,
Herbert

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors