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

[Doodle]

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!

[Krishna09]

@lbendlin 

[Krishna09]

@lbendlin 

[Krishna09]

Hello @Doodle ,

I have same issue from two weeks. Is you problem solved? 

Can you please share with me the solution in brief please?

[lbendlin]

Use OAuth

Use API 14 instead of 15

Use Sharepoint.Contents() instead of Sharepoint.Files()

[Krishna09]

Hello @lbendlin ,

If I change api and replace sharepoint.contents(). I received below error.

[lbendlin]

Clear permissions and reauthenticate.

[Krishna09]

Thank you very much for quick reply @lbendlin . I sgined out andssigned in back. Do you mean that? If not could you please tell me how to clear permissions in dataflow . I donot see any option here besides to cancel and go back to initial page.

[lbendlin]

there are a couple of ways to do that but starting over is the fastest, unfortunately.

Is this on-premise sharepoint or sharepoint online?

[Krishna09]

@lbendlin ,

Its online Sharepoint. 

I tried to create new dataflow and updated API and sharepoint.files(). But I do not see table. there was no change. So I addded Imported csv step in script. 

Now it show this error.

[Krishna09]

@lbendlin ,

This is the step I am struck.

[lbendlin]

The screenshot is blurry.