Forum Discussion
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
- Anonymous5 years ago
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.
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
1 Reply
- AnonymousNot applicable
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.
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