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
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.

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous ,

         

        If you get data from sharepoint excel file, you can just import data from the arrow icon on the left-bottom of power bi service, then enter your sharepoint site url. And import mode.

        This dataset will be refreshed from sharepoint without gateway. The screenshot of dataset settings as the following picture. No Gateway Connection.

        If you have multiple data sources, then you need to install gateway.

        For more details you can refer these articles.

        Get data from Excel workbook files - Power BI | Microsoft Docs

        Refresh a dataset created from an Excel workbook - cloud - Power BI | Microsoft Docs

         

        Best Regards

        Community Support Team _ chenwu zhu

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.