This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hello, I am following the next resource in order to refresh automatically a model from within Azure Analysis Services with the help of Data Factory:
"https://github.com/NandanHegde15/Azure-DataFactory-Generic-Pipelines/tree/main/Azure%20Analysis%20Service/ProcessAzureAS"
The error I get is the following one:
" The credentials provided cannot be used for the SQL source. (Source at example.database.windows.net;exampledb.). The exception was raised by the IDbCommand interface. "
Service principal used is already added as an Admin into Azure Analysis Services
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi @PyThor ,
Thanks for using Microsoft Q&A!!
If I understand correctly, you are trying to refresh the cube using ADF using sample link shared in the question.
PL_Cmn_ProcessCube.json or PL_Cmn_ProcessCube (without Linked service and Datasets).json from the GitHub repo ? Thanks
Saurabh
Hi @Saurabh Sharma , thank you for your answer!
I am using the sample pipeline: "PL_Cmn_ProcessCube.json" ( the one that contains Linked service and Datasets).
The activity that has problems is: "ACT_Cmn_CheckRefreshStatus", and the error message it has is the one from my first post.
Hey @PyThor ,
Based on the error message , my assumption is the credential provided to access Azure SQL DB from AAS is not correct.
Can you please confirm what authentication you are using to access for that?
And parallelly can you please try refreshing the cube manually once and confirm whether it is a success?
Hi @Nandan Hegde , I'm using a service principal that is listed as admin in AAS.
Manual refresh works, but only after refreshing the credentials there, as well.
Hey,
Can you please provide the screenshot of your connection details?
And also, parallelly can you please connect the Azure DB via a SQL account (just for temp debugging purpose) and try executing the ADF pipeline as this would help us pinpoint whether the issue is in ADF pipeline or while leveraging the SP in connection .
Hi @Nandan Hegde ,
Tested it with a SQL Authentication, pipeline still fails. Testing the connection inside the Linked Service works...
Hey,
Sorry for the confusion.
What I am asking is updating the connection details in AAS :
Steps:
There update the connection to SQL auth and provide SQL creds rather than Service principal and test out the ADF pipeline and provide an output here for us yo debug further.
Hi @Nandan Hegde ,
I scrolled around AAS via SSMS connection and found out that the connections are set up to be "OAuth2" type and the "Expires" tag was passed with like 10 days or so. I updated the tag ( set the tag "Expires" to a later date ) and tried again running the ADF pipeline.
The models inside activity: "ACT_Cmn_CheckRefreshStatus" are still failed, but with a different error message now:
" The given credential is missing a required property. Data source kind: SQL. Authentication kind: OAuth2. Property name: AccessToken. The exception was raised by the IDbConnection interface."
Hey,
Can you please try updating the connection to SQL auth once rather than OAUTh and try executing the ADF as stated above, as it would help us narrow down the cause.
And also please send the snip of connection properties here
Hi @Nandan Hegde ,
I attached the snip of the connection. I can only generate it as script, and not really sure how to change it to sql auth based on this script.
