Power BI Desktop not finding SharePoint folder

[adayweld]

I have two at least two SharePoint folders, URLs listed below, that "get data" is not finding in the "transform data" search. Any ideas?

https://weldgov.sharepoint.com/sites/PMO/Other

https://weldgov.sharepoint.com/sites/PMO/BI&Analytics

[v-henryk-mstf · Accepted solution]

Hi @adayweld ,

When using SharePoint folders, you need to provide the know-how for the root folder, then select a file for the function in the folder that needs to be converted, and when you go to the query that does the function implementation, after the first step (where you have all the information about the file/folder), you filter out only the folders you need by file location.

Or you can try below solution:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@adayweld , The column having Binary should have the option to merge if needed ( the second column)