Forum Discussion
Super UserBest practice to run only one sharepoint.files
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?
Super Userpretty 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.
Super UserOk 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
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?