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

Question

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

wabreza · Answer

Thanks for reporting this issue. &nbsp;Can you please log an issue with your repro steps in our Github site&nbsp;@&nbsp;https://github.com/Microsoft/PowerBI-Cli&nbsp;

kobaldm · Answer

ok. I will. I wonder that this basic Function&nbsp;is not working.michael&nbsp;

kobaldm · Answer

Thanks for fixing the issue. I now can upload the connection string.Below my Request&nbsp;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.&nbsp;Did anybody got this to work ?&nbsp;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&nbsp;

wabreza · Answer

Can you explain the new issue? &nbsp;You mentioned everything is up-to-date, but the data is the same...? &nbsp;Has the underlying data&nbsp;changed in your datasource?

kobaldm · Answer

Yes the data changed. A new row is added every 30 sec. I would expect all visuals get updated when I trigger updateallconnections. They are not.But if you go into zoom mode of a specific visual you get the time when the dataset was updated. It is the time I triggered updateallconnections. But still all visuals rely on the old data initial data i loaded powerbi embedded.Does this help ?&nbsp;

Forum Discussion

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

Related content

ADBC Bug

Restricted View Policy Bug

Bookmark Bug?

Bug: Filters are not working properly

Power Query Table.NestedJoin bug