Connect Power BI Desktop to file folder on OneDrive for Business

The solution proposed by Anonymous works, however with a serious caveat: you can only connect to the root folder of OneDrive, not to subfolders, which would be the correct and ideal. To restrict the query it is necessary to open the Query Editor and filter through the column that shows the path to the subfolder, which is what works, however, is inefficient. The ideal solution would be to allow connection to one or more subfolders within the OneDrive root folder, depending on the context of the project you are working on. Even so I am very happy, because it represents a breakthrough. I'll point it out as solved, but making clear here the need for an enhancement that allows access to subfolders. I will also test the solution proposed by yossifisch, whom I also thank for the help.

You're all amazing, thank you!

Wow Anonymous; thanks Lydia!

This is very important to small business solutions developers. I'll try this solution now in this morning, and return to confirm.

Thank you Lydia, but I have a problem with my user name. It seams that because my user name is [email protected] it does not work. We tried with other colleages who had no peroid in the user and it work...Any solution to that? Thanks again,

María