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
