Forum Discussion
Power Query takes too long to load when connected into Sharepoint Files
Hi Anonymous ,
I have created some custom function for the import of files from SharePoint that reduce load time considerably if your SharePoint has lots of files already: Improve File Import from SharePoint in Power BI and Power Query – (thebiccountant.com)
Hi Anonymous ,
I have created some custom function for the import of files from SharePoint that reduce load time considerably if your SharePoint has lots of files already: Improve File Import from SharePoint in Power BI and Power Query – (thebiccountant.com)
Vielen Dank Imke! I went into your blog and saw the instructions and the video, it actually worked but in this case, the files are refreshed on a daily basis and the name of the download needs to have the date of the current date so the name will change every day.
So for the Single File function, is there a way of setting a condition or to specify that it only takes a specific text?
Before trying to apply your function, I was setting the connection to the SP folder with 'SharePoint.Contents' with the root path until the 5th slash as well, and then one step of Navigation and the 3rd step which gives me the specific file is the one that Filters by the name of the file, in this case: Text.Contains([Name], "EKKO")), I filter by that text and it gives me the file, no matter the date.
Thanks in advance.