static void Main()
{
string DatabaseName = "Demo Dataset 1";
DatasetManager.ConnectToPowerBIAsUser();
Database database = DatasetManager.CreateDatabase(DatabaseName);
DatasetManager.CreateWingtipSalesModel(database);
//string newDatabaseName = "My Cloned Dataset Copy";
//DatasetManager.CopyDatabase(DatabaseName, newDatabaseName);
//database = DatasetManager.CreateDatabase(newDatabaseName);
}
static void Listing6()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
Model dataset = server.Databases.GetByName("Tom Demo").Model;
Table tableSales = dataset.Tables.Find("Products");
Column columnListPrice = tableSales.Columns.Find("List Price");
columnListPrice.FormatString = "$#,##0.00";
dataset.SaveChanges();
}
static void Listing3()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
string targetDatabaseName = "Tom Demo";
Database database = server.Databases.GetByName(targetDatabaseName);
Model datasetModel = database.Model;
foreach (Table table in datasetModel.Tables)
{
Console.WriteLine(table.Name);
}
}
static void Listing7()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
Model dataset = server.Databases.GetByName("Tom Demo").Model;
Table tableSales = dataset.Tables.Find("Sales");
foreach (Column column in tableSales.Columns)
{
column.IsHidden = true;
}
dataset.SaveChanges();
}
static void Listing5()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
Model dataset = server.Databases.GetByName("Tom Demo").Model;
Table tableSales = dataset.Tables.Find("Sales");
Measure salesRevenue = new Measure();
salesRevenue.Name = "Sales Revenue";
salesRevenue.Expression = "SUM(Sales[SalesAmount])";
salesRevenue.FormatString = "$#,##0.00";
tableSales.Measures.Add(salesRevenue);
dataset.SaveChanges();
}
static void Listing2()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
string targetDatabaseName = "Tom Demo";
Database database = server.Databases.GetByName(targetDatabaseName);
Console.WriteLine("Name: " + database.Name);
Console.WriteLine("ID: " + database.ID);
Console.WriteLine("ModelType: " + database.ModelType);
Console.WriteLine("CompatibilityLevel: " + database.CompatibilityLevel);
Console.WriteLine("LastUpdated: " + database.LastUpdate);
Console.WriteLine("EstimatedSize: " + database.EstimatedSize);
Console.WriteLine("CompatibilityMode: " + database.CompatibilityMode);
Console.WriteLine("LastProcessed: " + database.LastProcessed);
Console.WriteLine("LastSchemaUpdate: " + database.LastSchemaUpdate);
}
static void Listing4()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
Database dataset = server.Databases.GetByName("Tom Demo");
Table tableSales = dataset.Model.Tables.Find("Sales");
foreach (Column column in tableSales.Columns)
{
Console.WriteLine("Coulumn: " + column.Name);
}
foreach (Measure measure in tableSales.Measures)
{
Console.WriteLine("Measure: " + measure.Name);
Console.WriteLine(measure.Expression);
}
}
static void Listing8()
{
string connectString = DatasetManager.GetUserConnectString();
Server server = new Server();
server.Connect(connectString);
string targetDatabaseName = "Tom Demo Starter";
Database database = server.Databases.GetByName(targetDatabaseName);
Model datasetModel = database.Model;
foreach (Table table in datasetModel.Tables)
{
foreach (Column column in table.Columns)
{
if (column.DataType == DataType.DateTime)
{
column.FormatString = "yyyy-MM-dd";
}
}
}
datasetModel.SaveChanges();
}