Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I am scraping excel files in a folder, using Power Query (in excel). This folder comes from a SharePoint site folder that contains extremly many files, and it takes very long time to filter and scrap this folder that I am intersted in (and crashing excel). I have therefore made a workaround where I use a synced folder. The problem is that there are many users that should be able to do this, so I have made a list in the excel file of intials that dynamically finds the local path for every user. But when I do this I am using two datasources, the local folder and the table within the excel file itself. Power Query does not allow me do this unless I change the privacy level to Always ignore privacy level. This works fine until another user opens the file, then he has to change the privacy level again, and when I open it after him I have to change the privacy level again. Is there a better workaround for this problem or am I doing this wrong?
Regards,
kristjan76
Hi,
Thanks for share your issue! I really appreciate. I have almost the same struggle. Did you find out the solution?
Hi @Kristjan76 ,
If I understand your scenario correctly that it will take very long time to filter and scrap the file in the SharePoint folder?
Actually, we could search the file directly like below in Power Query.
Best Regards,
Cherry
Thanks for your answer, this would not help, you are actually doing the same thing as I did, apart from the fact that you are filtering a filename (which I do not have) instead of a folder. I also guess that the reason for being so slow is that it needs to join number of files in that folder, and retriving them from SharePoint is just slower than from your local drive.
Regards,
Kristjan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.