private static void Test_Serialization(PBIAPIClient pbic)
{
PBIDataset dataset = new PBIDataset("myDataset", PBIDefaultMode.Streaming);
dataset.ParentPowerBIAPI = pbic;
dataset.SyncFromPowerBI(); // check if a Dataset with the same ID or Name already exists in the PowerBI-Service
PBITable salesTable = new PBITable("Facts"); // create a PBI table manually
salesTable.AddColumn(new PBIColumn("ProductKey", PBIDataType.Int64)
{
IsHidden = true
}); // hiding a column
salesTable.AddColumn(new PBIColumn("SalesDate", PBIDataType.DateTime)
{
FormatString = "yyyy-MM-dd"
}); // setting the Formatstring
salesTable.AddColumn(new PBIColumn("Amount_BASE", PBIDataType.Double)
{
FormatString = "$ #,##0.00", IsHidden = true
});
string x = PBIJsonHelper.SerializeObject(dataset);
}
private static void Sample_Dataset_Rebind(PBIAPIClient pbic)
{
PBIGroup powerBIGroup = pbic.GetGroupByName("ApiClient Test");
PBIReport powerBIReport = powerBIGroup.GetReportByName("Test Rebind");
PBIDataset newPowerBIDataset = powerBIGroup.GetDatasetByName("AdventureWorksDW2016");
powerBIReport.Rebind(newPowerBIDataset);
}
private static void Test_Parameters(PBIAPIClient pbic)
{
PBIDatasetParameters parameters = new PBIDatasetParameters();
parameters.Items.Add(new PBIDatasetParameter("myTextParameter", "myUpdatedValue2"));
parameters.Items.Add(new PBIDatasetParameter("myIntParameter", "789"));
PBIDataset dataset = pbic.GetDatasetByName("myDataset");
dataset.UpdateParameters(parameters);
}
private static void Sample_Dataset_Refresh()
{
// AppID: the ID of the Azure AD Application
string ApplicationID = ConfigurationManager.AppSettings["PBI_ApplicationID"];
PBIAPIClient powerBIClient = new PBIAPIClient(ApplicationID);
PBIDataset powerBIDataset = powerBIClient.GetDatasetByName("TestRefresh");
powerBIDataset.Refresh();
}
private static void Test_Rebind(PBIAPIClient pbic)
{
PBIGroup myGroup = pbic.GetGroupByName("RebindAPI"); // "My Workspace"
PBIReport srcReport = myGroup.GetReportByName("Report");
PBIDataset targetDataset = myGroup.GetDatasetByName("Dataset1_Copy");
//srcReport.Clone("Report_Cloned", myGroup, targetDataset);
srcReport.Rebind(targetDataset);
}
private static void Test_Rebind(PBIAPIClient pbic)
{
PBIGroup myGroup = pbic; // "My Workspace"
PBIReport srcReport = myGroup.GetReportByName("asdf");
PBIDataset targetDataset = myGroup.GetDatasetByName("Adobe Analytics Traffic Analysis");
srcReport.Clone("asdf2", myGroup, targetDataset);
srcReport.Rebind(targetDataset);
}
private static void Sample_DataTable(PBIAPIClient pbic)
{
PBIDataset dataset = new PBIDataset("MyPushDataset", PBIDefaultMode.Push);
dataset.ParentPowerBIAPI = pbic;
dataset.SyncFromPowerBI(); // check if a Dataset with the same ID or Name already exists in the PowerBI-Service
// create a regular DataTable - but could also be derived from a SQL Database!
DataTable dataTable = new DataTable();
/* populate the dataTable */
// create a PBI table from a regular DataTable object
PBITable productsTable = new PBITable(dataTable);
// publish the table and push the rows from the dataTable to the PowerBI table
productsTable.PublishToPowerBI(true);
}
public static void AddOrUpdateTable(this PBIDataset dataset, PBITable newTable)
{
for (int i = 0; i < dataset.Tables.Count; i++)
{
if (dataset.Tables[i].Name == newTable.Name)
{
dataset.Tables[i].Columns = newTable.Columns;
dataset.Tables[i].Measures = newTable.Measures;
dataset.Tables[i].IsHidden = newTable.IsHidden;
return;
}
}
newTable.ParentDataset = dataset;
newTable.ParentObject = dataset;
newTable.ParentGroup = dataset.ParentGroup;
dataset.Tables.Add(newTable);
}
private static void Sample_DataTable()
{
// AppID: the ID of the Azure AD Application
string ApplicationID = ConfigurationManager.AppSettings["PBI_ApplicationID"];
PBIAPIClient powerBIClient = new PBIAPIClient(ApplicationID);
PBIDataset dataset = new PBIDataset("MyPushDataset");
dataset.PBIDefaultMode = PBIDefaultMode.Push;
dataset.ParentPowerBIAPI = powerBIClient;
dataset.SyncFromPowerBI(); // check if a Dataset with the same ID or Name already exists in the PowerBI-Service
// create a regular DataTable - but could also be derived from a SQL Database!
DataTable dataTable = new DataTable();
/* populate the dataTable */
// create a PBI table from a regular DataTable object
PBITable productsTable = new PBITable(dataTable);
// publish the table and push the rows from the dataTable to the PowerBI table
productsTable.PublishToPowerBI(true);
}
private static void Sample_PushDataset(PBIAPIClient pbic)
{
string datasetName = "MyPushDataset";
string tableNameFacts = "MySalesTable";
PBIDataset dataset = new PBIDataset(datasetName, PBIDefaultMode.Push);
dataset.ParentPowerBIAPI = pbic;
dataset.SyncFromPowerBI(); // check if a Dataset with the same ID or Name already exists in the PowerBI-Service
PBITable salesTable = new PBITable(tableNameFacts); // create a PBI table manually
salesTable.AddColumn(new PBIColumn("ProductKey", PBIDataType.Int64)
{
IsHidden = true
}); // hiding a column
salesTable.AddColumn(new PBIColumn("SalesDate", PBIDataType.DateTime)
{
FormatString = "yyyy-MM-dd"
}); // setting the Formatstring
salesTable.AddColumn(new PBIColumn("Amount_BASE", PBIDataType.Double)
{
FormatString = "$ #,##0.00", IsHidden = true
});
salesTable.AddColumn(new PBIColumn("Quantity_BASE", PBIDataType.Int64)
{
FormatString = "#,##0", IsHidden = true
});
salesTable.Measures.Add(new PBIMeasure("Sales Amount", "SUM('{0}'[{1}])", tableNameFacts, "Amount_BASE")); // adding a measure
salesTable.Measures.Add(new PBIMeasure("Quantity", "SUM('{0}'[{1}])", tableNameFacts, "Quantity_BASE")); // adding a measure
dataset.AddOrUpdateTable(salesTable);
Console.WriteLine("Publishing to PowerBI Service ... ");
dataset.PublishToPowerBI();
Console.WriteLine("Done!");
}
private static void Sample_Dataset_Refresh(PBIAPIClient pbic)
{
PBIDataset powerBIDataset = pbic.GetDatasetByName("TestRefresh");
powerBIDataset.Refresh();
}
private static void Sample_Create_Model(PBIAPIClient pbic)
{
string datasetName = "MyPushDataset";
string tableNameFacts = "MySalesTable";
string tableNameProducts = "MyProductTable";
PBIDataset dataset = new PBIDataset(datasetName, PBIDefaultMode.Push);
dataset.ParentPowerBIAPI = pbic;
dataset.SyncFromPowerBI(); // check if a Dataset with the same ID or Name already exists in the PowerBI-Service
PBITable salesTable = new PBITable(tableNameFacts); // create a PBI table manually
salesTable.AddColumn(new PBIColumn("ProductKey", PBIDataType.Int64)
{
IsHidden = true
}); // hiding a column
salesTable.AddColumn(new PBIColumn("SalesDate", PBIDataType.DateTime)
{
FormatString = "yyyy-MM-dd"
}); // setting the Formatstring
salesTable.AddColumn(new PBIColumn("Amount_BASE", PBIDataType.Double)
{
FormatString = "$ #,##0.00", IsHidden = true
});
salesTable.Measures.Add(new PBIMeasure("Sales Amount", "SUM('{0}'[{1}])", tableNameFacts, "Amount_BASE")); // adding a measure
// create a regular DataTable - but could also be derived from a SQL Database!
DataTable dataTable = new DataTable(tableNameProducts);
dataTable.Clear();
dataTable.Columns.Add("ProductKey", typeof(int));
dataTable.Columns.Add("ProductName", typeof(string));
DataRow prod1 = dataTable.NewRow();
prod1["ProductKey"] = 1;
prod1["ProductName"] = "Bikes";
dataTable.Rows.Add(prod1);
DataRow prod2 = dataTable.NewRow();
prod2["ProductKey"] = 2;
prod2["ProductName"] = "Clothing";
dataTable.Rows.Add(prod2);
// create a PBI table from a regular DataTable object
PBITable productsTable = new PBITable(dataTable);
dataset.AddOrUpdateTable(salesTable);
dataset.AddOrUpdateTable(productsTable);
dataset.Relationships.Add(new PBIRelationship("MyRelationship", salesTable.GetColumnByName("ProductKey"), productsTable.GetColumnByName("ProductKey")));
Console.WriteLine("Publishing to PowerBI Service ... ");
dataset.PublishToPowerBI();
Console.WriteLine("Done!");
salesTable.DeleteRowsFromPowerBI();
PBIRow row = salesTable.GetSampleRow();
row.SetValue("ProductKey", 1);
row.SetValue("SalesDate", DateTime.Now);
row.SetValue("Amount_BASE", 100);
salesTable.PushRowToPowerBI(row);
salesTable.PushRowToPowerBI(new PBIRow(new Dictionary <string, object> {
{ "ProductKey", 2 }, { "SalesDate", DateTime.Now }, { "Amount_BASE", 50.90 }
}));
salesTable.PushRowToPowerBI(new PBIRow(new Dictionary <string, object> {
{ "ProductKey", 1 }, { "SalesDate", DateTime.Now }, { "Amount_BASE", 70.3 }
}));
salesTable.PushRowToPowerBI(new PBIRow(new Dictionary <string, object> {
{ "ProductKey", 2 }, { "SalesDate", DateTime.Now }, { "Amount_BASE", 150.70 }
}));
productsTable.PushRowsToPowerBI();
}
