Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Add data source (Sharepoint) for the gateway



I am new to dataflow, and I have a problem adding sharepoint source in the gateway. Under data source setting, the authentication method is either window or anonymous. I am using microsoft account to connect to sharepoint in the power bi Desktop. I do not have any information (username & password) for the window. How to deal with that? What is your suggestion for the sharepoint connection?


Thank you


Best, Qianru

Super User II
Super User II

Hi there

Are you connecting to a file in SharePoint or a List?

If it is a file, you could put in the full URL list to the file, which should then prompt for an organizational account.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog



I am using sharepoint which does not offer microsoft account in the authentication method. Is there a way to connect to gateway through microsoft, because I do not have information for window?


Thank you,


Best, Qianru 

Hi there

Is this SharePoint Online or SharePoint on Premise?

And are you connecting to a SharePoint List or a file stored in SharePoint?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors