Best practice to run only one sharepoint.files

[jaryszek]

Hi Guys,

I want to have one datasource from SharePoint.Files (Csv tables) and based on this build seperated queries. 

What is the best practice ? 

I should build CSV tables in a source like add column here with Csv.Document ?:

 
and from query just filter specific row and expand table column?

Or i should create a table from binary for each seperated query? 
I want to avoid refreshing in the loop SharePoint source a lot of times...

Best,
Jacek

[v-kpoloju-msft]

Hi @jaryszek, 

May i know has your issue been resolved? If the response provided by the community member @lbendlin, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @jaryszek,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[lbendlin]

pretty much . Table.AddColumn with a Csv.Document ingestion of the [Content] value.  You need to specify the encoding and the quoting.  Then you can drop the [Content] column and expand the newly created column for an automatic append.

Writing a blog entry on this topic at the moment.

[jaryszek]

Ok if i use Table.AddColumn with a Csv.Document and get all tables in SharePoint source and after that I will create Query1, and in this query i will filter all sharepoint query for specific query, if power query will rerun twice? If it will Refresh all sharepoint files query and after refresh them again it will refresh for filtering specific table within seperate query?

AllSharePointQueries with Add.TableColumn Csv table --> Specific table filtered within seperate query -> if AllSharePointQueries will be refreshed twice? 

Best, 
Jacek

[lbendlin]

Here is a very rough draft of my blog entry - see if this clarifies things already.

[jaryszek]

thanks,

so now when you will create seperate query, your source table will be refreshed once only no matter if seperated query is filtering it? 

Best,
Jacek

[lbendlin · Accepted solution]

correct-ish.  There is no guarantee for that though.  Chris Webb's BI Blog: Why Does Power BI Query My Data Source More Than Once?