Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ilyasss
Helper II
Helper II

Best practice to get access to a sharepoint folder

Hello guys, 

 

I hope you are well. 

 

I'm looking to retrieve some excel files from a sharepoint folder to combine them. 

 

I've started to use the function SharePoint.Files but it scans all the files on sharepoint before getting anything. There are hundreds thousands of files so it's too slow to use it. 

 

Do you know if there is a better way to get a direct access to the folder avoiding PBi to scan all the files on sharepoint ? 

 

Many thanks for your help, 

 

4 REPLIES 4
mahoneypat
Employee
Employee

You can try to change Sharepoint.Files() to SharePoint.Contents() to see if that works better for you.  Or you can add a Filter step on the FolderPath before you start combining files.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hello @mahoneypat  and thank you. 

 

Using SharePoint.Contents() instead of Sharepoint.Files() seems to be a good idea. 

 

Nevertheless, when I try to open the folder I have this error : 

 

PBi forum 14-05.jpg

 

Do you know how to fix this ? 

 

Regards, 

 

Not sure.  That should work.  Remember that M is case sensitive.  Does your [Name =  <yourfoldername>] part match case too?

 

Here one tip to help troubleshoot.  Connect again and navigate where you see your folder and a hyperlink of "Table" next to it. Click to the right of the hyperlink (not on it) to preview the contents.  Is it empty (null)?  If so, put a file there and try again.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thank you @mahoneypat

 

It took me a lot of time to identify the issue. The error was caused because one of the folder name contained a special character, in this case it was "&". 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.