question

SahilMehta-3190 avatar image
0 Votes"
SahilMehta-3190 asked SathyamoorthyVijayakumar-MSFT commented

Copy data from AAS via ADF



I have a requirement wherein I need to copy data from AAS via ADF and I am following the below blog :

https://datasharkx.wordpress.com/2021/03/16/copy-data-from-ssas-aas-through-azure-data-factory/

But we have a scenario wherein we have MFA configured in our accounts. So how should we create a linked server?

azure-data-factoryazure-analysis-services
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SahilMehta-3190,

Thanks for the question and using MS Q&A platform.

If my understanding is correct you'd like to know how to create a linked server using a SQL instance? Can you please let me know what version are you makin use of ?

0 Votes 0 ·
SahilMehta-3190 avatar image SahilMehta-3190 SathyamoorthyVijayakumar-MSFT ·

Yes,
I am trying to create a lined server on SQL 2012 and SQL 2016 to Azure analyis service and the login account has MFA set up because of which unable to do it.
So how to proceed in such scenario

0 Votes 0 ·

Hello @SahilMehta-3190,

Thanks for getting back.

I came across a similar discussion in the below thread - The Answer by Pradeep talks about handling the MFA. Just wanted to understand whether you have already tried the below :

https://docs.microsoft.com/en-us/answers/questions/276132/creating-linked-server-to-connect-to-azure-analysi.html

0 Votes 0 ·
Show more comments

0 Answers