Excel Connection String

RuthBallinger
Posts: 2
Joined: Thu Apr 09, 2020 5:36 pm

Excel Connection String

Postby RuthBallinger » Wed Jun 17, 2020 1:30 am

Using Get data from excel will generate a string like

Provider=MSOLAP.8;Integrated Security=ClaimsToken;Persist Security Info=True;Initial Catalog=sobe_wowvirtualserver- [ ####################] ;Data Source=pbiazure://api.powerbi.com;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Identity Provider=https://login.microsoftonline.com/common, https://analysis.windows.net/powerbi/api, [ #########################] ;Update Isolation Level=2

By comparing strings I can see that the first string is to the dataset and the second on is the userid.

But I cannot find the dataset string anywhere up in BI service (so I cannot change the string eg to the same dataset in a different workspace). Matt, if you see this, on the recent Supercharge course you mentioned this briefly but did not actually find where we could identify the string of a dataset. The only way I can find it at the moment is by creating a connection and seeing what turns up. But it must be visible somewhere.

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest