Unable to Set Up Gateway Connection to Excel File on Sharepoint

Hi Anne,

Thank you for the forum question.

Just to make sure that you have connected to the Excel file correct. The link below shows you have we should connect to SharePoint:
https://www.youtube.com/watch?v=XuLnSYjmsJo

The error you got indicate that there is something wrong with the connection, but I find it strange that you can access the data in Power BI desktop but you get the problem when you publish.

I have searched for answers on Google and found a few things you can try to troubleshoot to resolve the issue:

Check the credentials (try re-entering the credentials to ensure they are accurate)

Verify Gateway configuration (You may need to review the Gateway settings and ensure that it is set up correctly)

Check network and firewall settings ( Ensure that there are no network or firewall restrictions preventing the connection between Power BI and SharePoint)

Review Power BI service limitations (Check if there are any limitations or restrictions in the Power BI service that may be causing the issue. Sometimes, certain features or connections may not be supported in the Web version)


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector