Forum Discussion

Doodle's avatar
Doodle
Advocate II
4 years ago

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 ...
Need Help
Krishna09's avatar
Krishna09
Helper III
3 years ago

Hello lbendlin ,

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

 

lbendlin's avatar
lbendlin
Super User
3 years ago

Clear permissions and reauthenticate.

  • Krishna09's avatar
    Krishna09
    Helper III
    3 years ago

    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's avatar
      lbendlin
      Super User
      3 years ago

      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's avatar
        Krishna09
        Helper III
        3 years ago

        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.