Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Connecting to PowerBI with c#

Hi,
am trying to set-up a little c# script to be run in an SSIS package to refresh dataset(s) after the ETL part of the solution has updated the DB.

 (code will be repeated in several ETL processes)
am initially just doing a proof-of-concept as a WindowsForms app (easier to work with).
Following code works....

string workspaceConnection = "powerbi://api.powerbi.com/v1.0/myorg/ProofOfConcept Test";
string userId = "[email protected]";
string password = "123456";
string connectStringUser = $"DataSource={workspaceConnection};User ID={userId};Password={password};";

Server server = new Server();
server.Connect(connectStringUser);

foreach (Database database in server.Databases)
{
database.Model.RequestRefresh(RefreshType.DataOnly);
database.Model.SaveChanges();
}

but I have a problem with the userid / password
i enter my credentials - the app accepts these and asks for a password (even tho i have entered one as in example)
is it possible to enter the password into the connection string ??
also - we are using Multi-Factor Auth - can this be bypassed on do we need a user specificslly setup to avoid MFA
thx

1 Reply