Esempio n. 1
0
        public void SyncFromPowerBI(PBIAPIClient powerBiAPI = null)
        {
            if (powerBiAPI == null)
            {
                if (ParentPowerBIAPI == null)
                {
                    throw new Exception("No PowerBI API Object was supplied!");
                }
                else
                {
                    powerBiAPI = ParentPowerBIAPI;
                }
            }

            PBIDataset temp;

            try
            {
                if (string.IsNullOrEmpty(this.Id))
                {
                    if (ParentGroup == null)
                    {
                        temp = powerBiAPI.GetDatasetByName(this.Name);
                    }
                    else
                    {
                        temp = ParentGroup.GetDatasetByName(this.Name);
                    }
                }
                else
                if (ParentGroup == null)
                {
                    temp = powerBiAPI.GetDatasetByID(this.Id);
                }
                else
                {
                    temp = ParentGroup.GetDatasetByID(this.Id);
                }

                if (temp != null)
                {
                    this.Id = temp.Id;
                    this.AddRowsAPIEnabled  = temp.AddRowsAPIEnabled;
                    this.ConfiguredBy       = temp.ConfiguredBy;
                    this.DefaultMode        = temp.DefaultMode;
                    this.Relationships      = temp.Relationships;
                    this.Datasources        = temp.Datasources;
                    this.GatewayDatasources = temp.GatewayDatasources;

                    this.LoadTablesFromPowerBI();
                    this.LoadDatasourcesFromPowerBI();
                }
            }
            catch (Exception e)
            {
            }
        }
Esempio n. 2
0
        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);
        }
        public void SyncFromPowerBI(PBIAPIClient powerBiAPI = null)
        {
            if (powerBiAPI == null)
            {
                if (ParentPowerBIAPI == null)
                {
                    throw new Exception("No PowerBI API Object was supplied!");
                }
                else
                {
                    powerBiAPI = ParentPowerBIAPI;
                }
            }

            PBIDataset temp;

            try
            {
                if (string.IsNullOrEmpty(this.Id))
                {
                    if (ParentGroup == null)
                    {
                        temp = powerBiAPI.GetDatasetByName(this.Name);
                    }
                    else
                    {
                        temp = ParentGroup.GetDatasetByName(this.Name);
                    }
                }
                else
                if (ParentGroup == null)
                {
                    temp = powerBiAPI.GetDatasetByID(this.Id);
                }
                else
                {
                    temp = ParentGroup.GetDatasetByID(this.Id);
                }

                if (temp != null)
                {
                    this.Id = temp.Id;
                    this.AddRowsAPIEnabled = temp.AddRowsAPIEnabled;

                    foreach (PBITable table in temp.Tables)
                    {
                        this.AddOrUpdateTable(table);
                    }
                }
            }
            catch (Exception e)
            {
            }
        }
Esempio n. 4
0
        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();
        }
Esempio n. 5
0
        private static void Sample_Dataset_Refresh(PBIAPIClient pbic)
        {
            PBIDataset powerBIDataset = pbic.GetDatasetByName("TestRefresh");

            powerBIDataset.Refresh();
        }