How to change Data source connection for deployment to PowerBI premium? about vsts-release-aas HOT 4 CLOSED

You can either use the set the option connectionType: sql an use the following options, but it only works if the source is a Azure SQL Database:

sourceSQLServer: 'SQLServer'
sourceSQLDatabase: 'Database'
sourceSQLUsername: 'Username'
sourceSQLPassword: 'Password'

Other option is to use the connectionType: advanced options to set the datasource connection yourself with the provided JSON:

datasources: |
[
  {
    "name": "<datasetname>",
      "authenticationKind": "UsernamePassword",
      "connectionDetails": {
      "address": {
        "server": "<sqlserver>",
        "database": "<databasename>"
      }
    },
    "credential": {
      "Username": "<username>",
      "Password": "<password>"
    }
  }
]

from vsts-release-aas.

Tried both the ways, still the data source connection is same as in model.bim file. And not getting replaced from the variables provided in task section.

In the task information, we can see that the data source connection option is not applicable for PowerBI premium as in screenshot above.

Can you please suggest a method to be used for deploying data source connections changed to PowerBI premium?

from vsts-release-aas.

Sorry, my bad: missed indeed the exception with Power BI Premium: I ran in too many issues/exceptions regarding the Power BI.

Easiest way is to use powerbi.com itself especially for the 'complex' OAuth connections.
Another way is to use the execute-aas-tmsl task to update the credentials via an XMLA command.
And maybe the Power BI REST APIs are working, although there is (now) a limitation stated that it is not working for datasets created via XMLA.

from vsts-release-aas.

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

from vsts-release-aas.