Forum Discussion

kobaldm's avatar
kobaldm
Icon for Helper I rankHelper I
10 years ago

datasets.setAllConnections not working in Node SDK and CLI Tool (BUG?)

I am not able to provide a correct connections string to this function. Neither with the PowerBi CLI Tool nor with the node SDK.

 

 

[ powerbi ] Error updating connection string
[ powerbi ] parameters[valueElement] must be of type object.

 

my connection string looks like this

 

-s connectionString: data source=MyAzureDB.database.windows.net;initial catalog=Sample2;persist securityinfo=True;encrypt=True;trustservercertificate=False

 

I not sure if this is a bug.

 

Does Any succeded in doing this ?

 

michael

 

 

Need Help
Tutorial Requests

9 Replies

    • kobaldm's avatar
      kobaldm
      Icon for Helper I rankHelper I
      10 years ago

      ok. I will. I wonder that this basic Function is not working.

      michael

       

      • kobaldm's avatar
        kobaldm
        Icon for Helper I rankHelper I
        10 years ago

        Thanks for fixing the issue. I now can upload the connection string.

        Below my Request

         

        WebResource {
  rawResponse: false,
  queryString: {},
  method: 'POST',
  headers: 
   { 'Content-Type': 'application/json; charset=utf-8',
     authorization: 'AppKey cAY0b0dCSSbg.......NzKAHhr7sukaxkZ9BfOL94gopjilKcdpLTKz0v2qMlw==' },
  url: 'https://api.powerbi.com/v1.0/collections/powerbistart/workspaces/112efff......60-05da61ded3ba/datasets/a1baf74f-8831-....e1ea91fbfe8b/Default.SetAllConnections',
  body: '{"connectionString":"data source=ServerName.database.windows.net;initial catalog=MyDB;persist security info=True;encrypt=True;trustservercertificate=False"}' }
Jsonstring [object Object]

        perhaps i missunderstood "initial catalog" ? I insert the db name there.

        It seams not to work. I double checked everysting. The report is not updated. Yes i use directQuery.

         

        Did anybody got this to work ?

         

        P.S: If i reload the ifame everything is uptodated. Also if i check when the report was last refreshed it shows me the date of i triggered setAllConnections(). But the Data is still the same.

        michael