Connect SSAS Tabular to Sharepoint without use of personal Organizational Account?

[Martin1986]

Hi,

I created a report on Power BI Desktop. In that report I retrieve a Excel file from Sharepoint Online. For Authentication I use OAuth, so with my personal organizational account.

I would now like to move the datamodel from my Power BI Desktop file to a SSAS Tabular model using Visual Studio and Tabular Editor.

My question now is: how can I set up a connection to Sharepoint Online without using my personal organizational account? I don't want the connection to depend on one person's login details. I want a more future-proof solution that is independent of inidividual employees. In the end I need Power BI Service to be able to schedule a refresh.

Is there any way to set this up? Can SSAS communicate with Sharepoint through other ways than a organizational account?

Thanks in advance.

[v-diye-msft · Accepted solution]

Hi @Martin1986 

If you're trying to connect SSAS Tabular to Sharepoint which far away with the power bi, I'd suggest you raise the question to the related forum:   https://social.msdn.microsoft.com/Forums/en-US/home  coz it's a little bit go over our work scope.