Loading an OneDrive folder in Power BI

[Draginko]

Hello,

I even feel bad for writing this trivial post, but I spent last 5 hours trying to figure this out, but it seems I am lost.

I need to load a folder, which is shared on OneDrive, where other department is submitting their weekly files, and to pick up the most recent one, so I can configure scheduled refresh in the workspace.

Normally this whole query is working fine, when utilized on locally stored folders, or online files stored in OneDrive.

But now I want to access whole OneDrive FOLDER, instead of FILE, and cannot make this work. I tried all the suggestions I found to use either Folder/SharePoint Folder/Web connector, but everytime there have been some problem:

Folder/SharePoint Folder connector was complaining about using absolute path, even though I used it - "https://company-my.sharepoint.com/personal/firstname_lastname_company_com/Documents/Documents/Projec...

This is the example of a intial script I am using and is working fine for all other instances as mentioned above (or for modification for SharePoint connector):

let
    Source = Folder.Files(
        "https://company-my.sharepoint.com/personal/firstname_lastname_company_com/Documents/Documents/Projects/Onboarding%20App/input_data"
        ),

    FilterRecentFile = Table.SelectRows(
        Source, 
        let 
            latest = List.Max(Source[Date created]) 
        in 
            each [Date created] = latest
            ),

    LatestFileName  = FilterRecentFile[Name]{0},
    
    #"LatestFile" = FilterRecentFile
    {
        [#"Folder Path"="https://company-my.sharepoint.com/personal/firstname_lastname_company_com/Documents/Documents/Projects/Onboarding%20App/input_data",Name=LatestFileName]
    }[Content],

    #"Imported Excel Workbook" = Excel.Workbook(#"LatestFile"),

For Web Connector the problem was that I was not able to select Microsoft Account for authentication, and all other options failed to authenticate.

I dont know what I am missing, or what I am making wrong, but any help would be appreciated. All the related posts I tried out are either quite old or not relevant, and all the guides are about handling OneDrive files, not folders.

Thanks