Sharepoint Gateway

Hey burtta ,

the dialog in your screenshot only shows that it is possible to configure a gateway connection sourcing data from your Sharepoint online site. As Sharepoint online is a web data source a gateway is not required.

Nevertheless, after you have published your Power BI report that contains the data model to the workspace(s), you need to authenticate, this must be done as publishing (from PBI Desktop to PBI Service), does not contain any authentication information. You can enter security information for Web data sources right below the "Gateway connection" using the "Data source credentials" settings:

Of course, you can also create a gateway connection that points to the Sharepoint site. I consider this beneficial, as it's more simple to maintain. Whenever someone is "taking over" the dataset inside the workspace, it becomes necessary to re-enter the Data source credentials. This might become necessary if someone wants to change the refresh schedule.
If your organization is forcing you to change the pwd regularly, then you have to re-enter the pwd as well. Here I recommend using a Managed Service Account that does not require pwd-change. But using a managed service account almost requires using a gateway connection, if you are going down that route, you must be aware that a Managed Service Account also needs to be granted permission to the Sharepoint site and also needs a Sharepoint license.

Hopefully, this helps to tackle your challenge.

Regards,

Tom