Can I connect to Power BI dataflows/SharePoint files using Generic ID?

[Anonymous]

Hi Everyone,

Is it possible to get data from Power BI dataflows and SharePoint (list/folder), and schedule a refresh using a generic ID instead of our own user ID?

Thank you for your help!

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/plan-for-administrative-and-service-accounts

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-configure-workspace-storage-settings

[Anonymous]

@amitchandak thanks for sharing the links, but I think it is only for the SharePoint server(?) and not for SharePoint Online. Thank you!

[Greg_Deckler]

@Anonymous - Yes, that should be possible to use something like a service account, sure.

[Anonymous]

@Greg_Deckler does it require to have a license (e.g. O365 license) to work? 

Our generic ID is now windows authenticated and it already has access to one of our SharePoint, but the connection does not work. Do you know some documentation regarding this?

Thank you!

[Greg_Deckler]

@Anonymous Huh, service accounts don't generally need licenses but might actually here for publishing purposes. Yeah, I think they do. Can't believe I don't know that off the top of my head. Because they are publishing to a workspace. I hate licensing questions. 😕