Connecting to PowerBI with c#

[Anonymous]

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 = "UserName@myOrg.com";
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

[v-shex-msft · Accepted solution]

Hi @Anonymous,

AFAIK,  power bi already provides the rest API for these operations, I'd like to suggest you use API to do manage power bi contents.

Getting Started with the Power BI API – Querying the Power BI REST API Directly (with C#) – Jeff Pries (jpries.com)

In addition, you can also take a look at the following link about use C# to manage power bi if helps:

C# Application that Manages Power BI - Microsoft Power BI Community

Regards,

Xiaoxin Sheng