SharePoint/OneDrive Query Issue: "Invalid credentials" on Service but ok on Desktop

Hi all,

Hoping someone might have some insight or recommendations for our issue. Details below, please help.

We have a recent issue where the dataflows/reports in PBI Service that query data from folders of Excel files on OneDrive/SharePoint are returning errors of "invalid credentials."  

In PBI Serivce, the query can access the source folder and bring in the file records (first 3 steps in image below). 

The issue occurs in the 4th step when the query tries to navigate to the specific file. We get the error in the yellow box and then try to "Configure Connection".

The credentials show as anonymous and when we change it to Microsoft Account and OAuth, the error persists. Notably, the Sharepoint address shown in the msg box is not at the folder level, rather, it references the file from the navigation step. (Duno if that is correct or relevant to the issue.)

If we copy and paste the exact same query into PBI Desktop, the query returns the Excel file without issue.

Thing we've tried:

1. Tried to refresh other reports/dataflows that query other ODB/Sharepoint folders, not just the one shown here, issue persists.

2. Tried to change owner of the dataflow to other colleagues and have them input their credentials and refresh. Issue persists.

3. Tried to create a completely new dataflow and query sharepoint folders and encounter same issue.

Any help is appreciated. Thanks!