Forum Discussion
Stop reading all text files again
- 6 years ago
Hi efilipe ,
Assuming that you have uploaded your text files into SharePoint Online, then you may use SharePoint Folder connector to combine or consolidate these files into a single table, transform the data in Query Editor, like "get the header of the file, and then split by position - voilá", see how to get SharePoint Online data from the link: Combining Excel Files hosted on a SharePoint folder with Power BI .
Then for the updated data today you may set Incremental refresh , and the Incremental refreshes only data that has changed. Since incremental refresh is Premium only feature, so you may need to purchase Power BI Premium capacity for your organization, see How to purchase Power BI Premium. Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service. See more detail steps: Incremental refresh in Power BI Premium , Incremental refresh for files in a Folder or SharePoint – Power BI
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
efilipe , refer if this can help
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
Well, you know it's not that... 🙂