New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AsPartitionProcessing with Application Service Principal ? #13

Open
baatch opened this Issue Mar 27, 2018 · 17 comments

Comments

Projects
None yet
3 participants
@baatch

baatch commented Mar 27, 2018

Hi,

Is it possible to use the AsPartitionProcessing with a service principal instead of username password?

@byobi

This comment has been minimized.

Collaborator

byobi commented Mar 27, 2018

short answer, yes.

longer answer, to get it working I ended up modifying the solution a bit as well as leveraging an Azure AD library (Microsoft.IdentityModel.Clients.ActiveDirectory.dll)

if you can wait until later in the week, I'll update the previous blog post.

@baatch

This comment has been minimized.

baatch commented Mar 27, 2018

@byobi very cool, thanks for contributing. I will wait for your updated blogpost =)

Is is possible to create your Azure function as a Visual Studio project and then deploy to Azure?

@christianwade

This comment has been minimized.

Member

christianwade commented Mar 28, 2018

Version 15 of TOM from the NuGet package below should work by plugging into the connection string (example below). For certificate based, can use "cert:thumbprint" in place of password
https://www.nuget.org/packages/Microsoft.AnalysisServices.retail.amd64/

string appId = "xxx";
string authKey = yyy";
string connString = $"Provider=MSOLAP;Data Source=asazure://southcentralus.asazure.windows.net/zzz;User ID=app:{appId};Password={authKey};";
Server server = new Server();
server.Connect(connString);

If you try it and issues, let me know!

@byobi

This comment has been minimized.

Collaborator

byobi commented Mar 28, 2018

that sure does look a lot easier than the path I went down :-(

image

@christianwade

This comment has been minimized.

Member

christianwade commented Mar 28, 2018

Yeah, are a few people doing that way, but I thought they were mainly MS internal :)

I have it on my todo list to blog about it, but you are free to beat me to it if you want!

@byobi

This comment has been minimized.

Collaborator

byobi commented Mar 29, 2018

this is definitely outside my wheel-house... what's the difference between your way and the way I'm doing it?

@christianwade

This comment has been minimized.

Member

christianwade commented Mar 29, 2018

The difference is TOM is dealing with getting the access token. TOM also deals with refreshing it under the covers so it doesn't expire for long running ops

@byobi

This comment has been minimized.

Collaborator

byobi commented Mar 29, 2018

good deal.. got it working your way... ty!

@christianwade

This comment has been minimized.

Member

christianwade commented Mar 29, 2018

Np!

@baatch

This comment has been minimized.

baatch commented May 3, 2018

Any updates on any blogs @byobi or @christianwade :) ?

@byobi

This comment has been minimized.

Collaborator

byobi commented May 3, 2018

@baatch - updates on what?

@baatch

This comment has been minimized.

baatch commented May 3, 2018

@byobi sorry for not checking your blog, it was already updated!
http://byobi.com/2018/04/implementing-as-partition-processing-via-azure-functions-part-2/

I'm going to check it out immediately, thanks alot :) !!

@baatch

This comment has been minimized.

baatch commented May 4, 2018

@byobi your fork repo is missing the AsPartitionProcessing.SampleAzureFunction project.

@byobi

This comment has been minimized.

Collaborator

byobi commented May 8, 2018

ugh - you're right! will have it updated shortly and report back.

@byobi

This comment has been minimized.

Collaborator

byobi commented May 8, 2018

@baatch - good to go now...

@baatch

This comment has been minimized.

baatch commented May 11, 2018

@byobi finally got it working in my environment with your Function sample! Thanks alot for sharing :)

@byobi

This comment has been minimized.

Collaborator

byobi commented May 11, 2018

@baatch - awesome, glad I could help!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment