cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juanito Frequent Visitor
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

Accepted Solutions
Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Steps order to download file already filtered to Power BI

@juanito

 

Yes, please refer to the screenshot below.

 

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

 

Best Regards,
Herbert

3 REPLIES 3
v-haibl-msft Super Contributor
Super Contributor

Re: Steps order to download file already filtered to Power BI

@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

juanito Frequent Visitor
Frequent Visitor

Re: Steps order to download file already filtered to Power BI

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

Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Steps order to download file already filtered to Power BI

@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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 98 members 1,596 guests
Please welcome our newest community members: