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 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
Super UserHere 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?