private async static Task QueryDatasets() { var dataClient = new DatasetsClient(pbi); var datasets = await dataClient.List(); foreach (var dataset in datasets.value) { Console.WriteLine("{0}\t{1}", dataset.name, dataset.id); } Console.WriteLine("Create a data set?"); Dataset created; if (Console.ReadKey().KeyChar == 'Y') { created = await dataClient.Create<resourceMeasures>("resourceManager", true); } else { created = (await dataClient.List()).value.First(ds => ds.name == "resourceManager"); } var tables = await dataClient.ListTables(created.id); ListTables(tables); //var table = dataClient.GetTable(created.id, tables.value.First().name); //ListColumns(table.columns); var table = await dataClient.UpdateTableSchema<resourceMeasures2>(created.id, tables.value.First().name); }
private async static Task QueryDatasets() { var dataClient = new DatasetsClient(pbi); var datasets = await dataClient.List(); foreach (var dataset in datasets.value) { Console.WriteLine("{0}\t{1}", dataset.name, dataset.id); } Console.WriteLine("Create a data set?"); Dataset created; if (Console.ReadKey().KeyChar == 'Y') { created = await dataClient.Create <resourceMeasures>("resourceManager", true); } else { created = (await dataClient.List()).value.First(ds => ds.name == "resourceManager"); } var tables = await dataClient.ListTables(created.id); ListTables(tables); //var table = dataClient.GetTable(created.id, tables.value.First().name); //ListColumns(table.columns); var table = await dataClient.UpdateTableSchema <resourceMeasures2>(created.id, tables.value.First().name); }
private async static Task GenerateData() { var dataClient = new DatasetsClient(pbi); var created = (await dataClient.List()).value.First(ds => ds.name == "resourceManager"); var tables = await dataClient.ListTables(created.id); var dataRows = new TableRows <resourceMeasures>(); for (int i = 0; i < 1000; i++) { dataRows.rows.Add(new resourceMeasures() { Id = Guid.NewGuid().ToString("n"), InServiceDate = DateTime.Now.AddYears(-4), IsRunning = true, LastMeasure = DateTime.Now, Name = "Engine" + i.ToString(), RPM = 6000, Temperature = 431.6 }); } await dataClient.ClearRows(created.id, tables.value.First().name); await dataClient.AddRows(created.id, tables.value.First().name, dataRows); while (true) { Console.Write("."); foreach (var row in dataRows.rows) { row.RPM = (int)(6000 * Math.Sin(Math.PI * (DateTime.Now.Second / 59D))); row.Temperature += new Random((int)DateTime.Now.Ticks).Next(-5, 5); row.LastMeasure = DateTime.Now; row.IsRunning = row.RPM > 1; Thread.Sleep(1); } await dataClient.AddRows(created.id, tables.value.First().name, dataRows); } await dataClient.ClearRows(created.id, tables.value.First().name); }
//Groups: The Get Tables operation returns a JSON list of Tables for the specified Dataset in a Group. //GET https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables //Get Tables operation: https://msdn.microsoft.com/en-US/library/mt203556.aspx static async Task<Tables> GetTables(string groupId, string datasetId) { var client = new DatasetsClient(pbi); return await client.ListTables(groupId, datasetId); }
private async static Task GenerateData() { var dataClient = new DatasetsClient(pbi); var created = (await dataClient.List()).value.First(ds => ds.name == "resourceManager"); var tables = await dataClient.ListTables(created.id); var dataRows = new TableRows<resourceMeasures>(); for (int i = 0; i < 1000; i++) { dataRows.rows.Add(new resourceMeasures() { Id = Guid.NewGuid().ToString("n"), InServiceDate = DateTime.Now.AddYears(-4), IsRunning = true, LastMeasure = DateTime.Now, Name = "Engine" + i.ToString(), RPM = 6000, Temperature = 431.6 }); } await dataClient.ClearRows(created.id, tables.value.First().name); await dataClient.AddRows(created.id, tables.value.First().name, dataRows); while (true) { Console.Write("."); foreach (var row in dataRows.rows) { row.RPM = (int)(6000 * Math.Sin(Math.PI * (DateTime.Now.Second / 59D))); row.Temperature += new Random((int)DateTime.Now.Ticks).Next(-5, 5); row.LastMeasure = DateTime.Now; row.IsRunning = row.RPM > 1; Thread.Sleep(1); } await dataClient.AddRows(created.id, tables.value.First().name, dataRows); } await dataClient.ClearRows(created.id, tables.value.First().name); }
//Groups: The Get Tables operation returns a JSON list of Tables for the specified Dataset in a Group. //GET https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables //Get Tables operation: https://msdn.microsoft.com/en-US/library/mt203556.aspx static async Task <Tables> GetTables(string groupId, string datasetId) { var client = new DatasetsClient(pbi); return(await client.ListTables(groupId, datasetId)); }