DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
20 stars 14 forks source link

Trouble updating datasource for tabular model #14

Closed JonHyeKnudsen closed 3 years ago

JonHyeKnudsen commented 4 years ago

It deploys alright, but when I try to update the data source it fails.

Getting this when trying to:

2020-02-06T20:57:52.8458415Z ##[section]Starting: Update SSAS tabular cube data source in Medlemsomraadet
2020-02-06T20:57:52.8588803Z ==============================================================================
2020-02-06T20:57:52.8589115Z Task         : Update SSAS tabular cube data source
2020-02-06T20:57:52.8589375Z Description  : Update SSAS tabular cube data source connection string to use an on-premise SQL Server database
2020-02-06T20:57:52.8589615Z Version      : 1.0.10
2020-02-06T20:57:52.8589785Z Author       : Dr. John Tunnicliffe
2020-02-06T20:57:52.8590077Z Help         : [More Information](https://github.com/DrJohnT/AzureDevOpsExtensionsForSqlServer/tree/master/extensions/DeployTabularModel)
2020-02-06T20:57:52.8590459Z ==============================================================================
2020-02-06T20:57:54.3274802Z Invoking Update-CubeDataSource from [DeployCube](https://github.com/DrJohnT/DeployCube) module with the following parameters:
2020-02-06T20:57:54.3286212Z AsServer:             BIDBtest
2020-02-06T20:57:54.3296119Z CubeDatabaseName:     Medlemsomraadet
2020-02-06T20:57:54.3306284Z SourceSqlServer:      BIDB
2020-02-06T20:57:54.3316046Z SourceSqlDatabase:    BI_DW
2020-02-06T20:57:54.3325707Z ImpersonationMode:    ImpersonateServiceAccount
2020-02-06T20:57:54.3335511Z ImpersonationAccount: 
2020-02-06T20:57:54.3345191Z ==============================================================================
2020-02-06T20:57:56.5782940Z ##[warning]MSG:UnableToDownload «https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409» «»
2020-02-06T20:57:57.7024267Z ##[warning]Unable to download from URI 'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409' to ''.
2020-02-06T20:57:58.1330243Z ##[warning]Unable to download the list of available providers. Check your internet connection.
2020-02-06T20:57:59.7826156Z ==============================================================================
2020-02-06T20:57:59.9043554Z ##[error]Error Error No match was found for the specified search criteria for the provider 'NuGet'. The package provider requires 'PackageManagement' and 'Provider' tags. Please check if the specified package has the tags.
2020-02-06T20:57:59.9461846Z ##[section]Finishing: Update SSAS tabular cube data source in Medlemsomraadet
DrJohnT commented 3 years ago

Last week I republished the extension last week having done quite a lot of work on this very topic. Could you please let me know if the latest version fixes your issue @JonHyeKnudsen?