Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Refresh sharepoint data from sharepoint excel file on Power BI.com

I can refresh the data in the desktop app, but not once I post the dataset on Power BI, I get a credentials error. I believe I need a gateway, but not 100% sure. 
Dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Here is the error:

 

arvindsingh802's avatar
arvindsingh802
Icon for Community Champion rankCommunity Champion
4 years ago

Please update the credentails under dataset credentails section

Use authentication type = OAuth2 and Privacy = Organizational

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Credentials is grayed out

    • arvindsingh802's avatar
      arvindsingh802
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Can you share screenshot expanding the gateway connection
      It seems you are using SharePoint 2013 onpremise 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Data Gateway expanded.