cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vedran
Frequent Visitor

Refresh AAS with two data sources, one of them SharePoint Online

Hi all, 

 

I would like to ask for some help 🙂 How to solve automatic refresh with Azure Automatic Account

 

So, model is in VS/SSDT, and two data sources are defined, first is Azure SQL database, second is Sharepoint Online (only one list).

When I try to publish from VisualStudio everything is fine. Problem is when I try to setup scheduled refresh with Azure Automatic Account. Before I added second source - Sharepoint Online List, everyhtning was fine, I was able to have runbook with 

Add-AzureRmAccount -Credential $AzureCred | Out-Null... and command Invoke-ProcessASDatabase -databasename.. was perfect, but after adding SharePoint list that script doesnt work anymore, contsanlty recieving error 
 
Invoke-ProcessASDatabase : Failed to save modifications to the server. Error returned: 'An error occurred during
On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_InvalidConnectionCredentials
Received error payload from gateway service with ID 772598: Async operation xxxxxx-fc29-45x03-93x8-77bxxxxxxxxxc86 is
faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessCredentialException: Missing or
invalid credentials for data source. Reason = '<pi>CredentialInvalid</pi>', DataSource =
'<pi><pi>SharePoint/https://xxxxxxxxxxxx.sharepoint.com/sites/Management</pi></pi>', DataSourceReference = '',
DataSourceOrigin = '', DataSourceReferenceOrigin = ''.
 
 
Credientals are the same for AAS admin and for SharePoint Online user, I also tried to setup On-Prem gateway (on machine and in Azure ) even there is no sense for that 🙂
 
Thanks a lot!
 Vedran
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @vedran,

 

It seems like you are using powershell script to refresh Azure AS, I'd like to suggest you post this to azure forums to get better support.

Azure Community Support | Microsoft Azure

Automation of Azure Analysis Services with Service Principals and PowerShell

 

Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @vedran,

 

It seems like you are using powershell script to refresh Azure AS, I'd like to suggest you post this to azure forums to get better support.

Azure Community Support | Microsoft Azure

Automation of Azure Analysis Services with Service Principals and PowerShell

 

Regards,

XIaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!